Thank for responding Doug. I do not get the dialog:
Opening this document will run the following SQL command:
SELECT * FROM [Drive:\Path\FileName].csv
I expect this to come up, but is does not. Even after I have manually made
the connection to the CSV file (and seen the data come up in the Word
document when I merge), it does not seem to save the connection. For when I
save the Word file (which has been successfully connected to the CSV data
source), I do not get the above message when I reopen the file, nor is the
CSV data file connected to the Word document.
The CSV file resides in a subfolder of My Documents. Hence it is not a long
network path. Any other ideas?
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org
"Doug Robbins - Word MVP" wrote:
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