FoxPro 2.6 and Excel

[gbymca]

When trying to using the get external data under Excel 2000 and try to run a New Database Query, and select <New Data Source>, name the database source, and then use the drop down list for selecting a driver, do not see Microsoft FoxPro Driver (*.dbf)(see drivers for VFP but not 2.6). Need to have driver for FoxPro 2.6 database accessible on this Windows 98 machine. Can anyone tell me how to locate this file and install it on the system.

Thank you in advance for your assistance.

 

[rgbean]

The VFP ODBC driver can easily access Fox2x data. (See

http://support.microsoft.com/default.aspx?scid=KB;en-us;q235357

- &quot;PRB: FoxPro ODBC Driver Replaced by Visual FoxPro ODBC Driver&quot; for details.)

The latest (last) ODBC version of the VFP driver is 6.1.8629.1. To find the version, you can go to the Control Panel and open the Data Sources (ODBC) applet. Next go to the Drivers tab and look for the Microsoft FoxPro VFP Driver. And alternative is to locate the file vfpodbc.dll (it's in my C:\WINDOWS\system32\ directory) and check the version tab on the file's property sheet. If this version isn't what's installed go to

http://msdn.microsoft.com/vfoxpro/downloads/addons/odbc.asp

and get it.

Rick