ODBC VFP From MS Query in Excel

[andrewlee]

Good Morning !

Has anyone else met (and solved) this problem?:

I am trying to run MS-Query in Excel 2002 (Win XP SP2) to query a FoxPro database.

When I select “Microsoft Visual FoxPro driver” as the driver in the “Create new data source” dialog box, I get this error message: “Microsoft Query. Driver does not support this function.”

I tried to add Visual Foxpro as an ODBC data source by following these steps:

1) Control Panel Administrative Tools Data
sources

2) System DSN (or User or File)

3) Add Microsoft Visual FoxPro Driver

This causes an error message to appear:

"You must first install the current version of the FoxPro ODBC driver".

According to the MSDN knowledge base the driver is VFPODBC.DLL, version 1.00.02.00, date 24/8/2001, and this is supplied with XP. This file is already installed in my Windows\System32 folder, and is listed as installed on Drivers tab of the ODBC Data Source Administrator window.

I can set up a DSN for every other ODBC driver on the list (except Oracle).

All works fine in Windows 2000, only XP is giving me this problem.

Does anyone have any suggestions?

 

[Neil Toulouse]

Not directly answering your problem, but we had a similar issue with setting up a VFP ODBC for use with Crystal Reports.

We found a way round it being to edit the Visual Foxpro Driver in the list and select the datasource from there, rather than adding a new one.

We then went on to discover that if you had to add it, then data source name had to be Visual Foxpro Driver to get it to work! "I love work. I can sit and stare at it for hours..."

 

[andrewlee]

Thanks FatSlug. I'll try that
Andy