>>>>Is there a way to get Office 2007 (word/excel) to open a VFP 9.0 DBF?
>>>>
>>>>(I know how to save a dbf in compatible formats, but I would rather not have to do that.)
>>>
>>>Why?
>>
>>Most of the client machines have excel on them, only mine has VFP on it.
>>
>>We are using a third party software that stores files in VFP format it would be nice for clients to be able to open them in excel. (Users damaging/altering the data is not an issue in this case.)
>>
>>I can do this in 2002 excel and word with no problem.
>>
>>Also mail merging directly from a DBF is nicer than having to export it first.
>
>You can install VFPOLEDB provider.
>Then From Ribbon:
>Data->From Other Sources->From Data Connection Wizzard->Other/Advanced->....
That works, pain in the ***, but it works. Thanks.