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
Edward Pikman
Independent Consultant