>>>>Hi everybody,
>>>>
>>>>I have a quick question:
>>>>Can we use VFPOleDb 9 with VFP8? Or should we download it for the version 8? If yes, can I also have a link if this is not too much to ask?
>>>>
>>>>Thanks a lot in advance.
>>>
>>>I think that you shouldn't have problems at all, though I never test this.
>>
>>The question is: when the VFP OleDb provider is used? Presently the only place we're using it (AFAIK) is the new functionality I implemented for creating Excel file. Do you think we can safely install it?
>>
>>In the meantime the problem with Excel is solved for one particular user.
>
>You query VFP tables from within Excel? I think there should be no problems to install it (Unfortunately I have no computer where only VFP8 is installed to test it). If you send SET ENGINEBEHAVIOR 80 before your query made your query VFP9 compatible you shouldn't have problems. Again I never play with it so I can't be sure. But VFP OleDB 9 must work with VFP8 tables.

Yes, using Re: Single call to excel Thread #1213473 Message #1213478 technique.

Thanks a lot for your help, Borislav. I hope we will be OK.