>>Here's an annoying one.
>>Word doesn't seem to be able to import data for a mail merge from VFP. Word doesn't seem to know how to deal with the odbc connection to a VFP table. The problem is compounded by the fact that when I try to configure the Fox 2.6 odbc driver I get a message saying that it is no longer supported and has been replaced by the VFP driver.
>>
>>Can anyone offer a suggestion. I have move an app from Fox to VFP 6.0 and now need to be able to do mail merges.
>>
>>Thanks
>>Stephen Bridgett
>
>Hi Stephen,
>
>Do you have the right ODBC driver for VFP6.0 installed and configured??
>Just guessing.
>
>A simple solutions is to just provide your data to Word in 2.6 format.
>Just open your table in VFP and use the copy command with the FOX2X clause to create a table in 2.6 format COPY TO FOX2X.
>
>And even simpler just provide a delimited file to WORD, the same format as they use for their MailMerge databases.
>If I recall correctly it consists of a kinda header, with the fields definiton followed by the data.
>
>Hope this gives you a clue where to look for?

Thanks Yves
Actually I found a couple of articles on msdn that indicates that your approach is the correct "workaround". However, even if I save the table (copy to) in fox2x format, I cannot open it as a datasource in Word. The problem is that although Word indicates that it has "MS Foxpro" connectivity, in fact the ODBC setup tool will not let me configure the driver. I get the message that it has been superceded by VFP's driver.

"Seems you can't there from here!"

Saving as type delimted works but, saving as anything is a cheesy workaround in a multi user environment, don't you agree?

Stephen

Stephen Bridgett
Hand Crafted Relational Database Solutions
Focusing on Visual Foxpro and Object Oriented Design
SBridgett@cyberus.ca