This is unacceptable to my client. They want typical users with only Office 97 and access to the VFP6 databases/tables, to be able to access the data. I am sure it can be done.


>Firstly, COPY TO ... TYPE FOX2x and try it.
>
>>As indicated in the initial post, all the ODBC drivers from the VS6 CD and the Office97 CD are installed.
>>
>>Ideas???
>>
>>>Obviously, it lacks VFP driver. You may either install it, or convert recordset to Fox2x (copy to ... type fox2x) on fly as part of your mailmerge program.
>>>
>>>>Thanx, but the problem is nothing so sophisicated.
>>>>
>>>>My client wants to be able to generate dozens of different form letters via MS Office97 using VFP data but as mentioned, I get CAN NOT OPEN DATA when attempting to open the table in Word (via, TOOLS, MAIL MERGE, FORM LETTERS, GET DATA, OPEN DATA, XXX.DBF).
>>>>
>>>>This should be easily doable. What am I missing?
>>>>
>>>>Ideas???
>>>>
>>>>
>>>>>Ian,
>>>>>
>>>>>Why not use OLE automation trough VFP ?
>>>>>
>>>>>or if you do not want to get to all this trouble,
>>>>>you can always use the 'copy to xxx type xls' in VFP.
>>>>>
>>>>>HTH
>>>>>
>>>>>Pascal