View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Problem Connecting to a CSV File in Word 2007

I am unable to replicate that problem when using Word 2007 on Vista
Business. I believe that it is unlikely that Vista Ultimate would make a
difference.

Are you getting the message

Opening this document will run the following SQL command:
SELECT * FROM [Drive:\Path\FileName].csv
Data from your database will be placed in the document. Do you want to
continue?

Where is the datasource located? Is it on a network with a long path
filename?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Chaplain Doug" wrote in message
...
Windows Vista Ultimate. Office 2007 Professional. Word 2007.

In Word 2003 I can connect my document to a .CSV file as my data source
and
it remembers and maintains the data connection when I save the file and
open
it later. However, in Word 2007 when I connect to a .CSV file as the data
source and save the file, the next time I open the file it is no longer
connected to the .CSV file. I have to go through all the steps to connect
to
a data source again. If I use a regular Excel file (.xls) I do not have
this
problem. I need to be able to have this work for a .CSV file.

Why is this simple function not working in Word 2007? Is it a known bug?
How Can I fix this issue???

Thanks for the help.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org