General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2008 Server
Hi Cetin.
I tried your suggestion and it worked as long as I selected Import External Data from the data tab... and
it seess the VFP data fine
However , if I select New Database Query, it gives me up a list of Drivers, and all the VDP ones come up with an error
It deos not allow me to create a new one.
I am not sure what is the difference between the Option to --> Import and --> New Database query ??
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only