Hi Cetin. Thnaks for your reply

PS: You asked how to do it manually, right? Otherwise it is easier with automation code.
Yes. The main purpose for this is that the Client wants to be able to go into Excel
and have Excel layouts linked to VFP tables and he then just 'Refreshes' and
the query re-exeutes..this means that the client can use Excel to link to the trables
(He has this linking to other Tables in another App)

I will try out your suggestions.
regards,
Gerard



>>Hi.
>>Am trying to create a query and connect Dbf or DBC from within Excel (2003) bur cannot
>>Tried following:
>>Data..Import External Data...New Datbase Query...New Data Source
>>There are about 10 different Foxpro drivers mentioned but ech of them fives error:
>> Specified driver could not be loaded
>>
>>Is there something else I need to do in Excel to access the tables ?
>>
>>Regards,
>>Gerard
>
>Gerard,
>Off the top of my head, there should be a selection to use a datalink file (or UDL). Create a .udl file and use VFPOLEDB driver. To create it:
>
>-Right click on desktop, add new text file
>-Rename to myVFPLink.udl (a dialog would pop up, yes sir I am sure change extension).
>-File's icon would change
>-DblClick and continue choosing 'OleDb driver for VFP'
>-Point that file from within Excel
>
>PS: You asked how to do it manually, right? Otherwise it is easier with automation code.
>
>Cetin