Does anyone know of ODBC drviers that let Access 2000 link to FoxPro 2.5 tables?
I haven't been able to find any or figure out how. Now, I have to open the FoxPro tables in Excel than save as a .csv and then import into Access. This quickly eats up disk space and I can't afford to do this much longer.
Thanks. Those don't seem to work, or I haven't been able to figure out how to use them. I think those ODBC drivers are for foxpro databases or a different version, and I need one for foxpro 2.5 tables. Whenever I try one of the existing drivers (for foxpro tables or databases), it says "file not in expected format" or soemthing.
I think that is the problem. I have Access 2000 which only has odbc drivers to visual foxpro--even the named drivers that say foxpro (not visual foxrpo) still use the VFP odbc drivers.
I've narrowed the problem down to the MDAC version. The current version I have loaded is 2.7, but the foxpro drivers I need are in MDAC 2.5 or earlier. I guess my question now is how do I manually load the earlier foxpro odbc drivers? Any clues?
Visual Foxpro driver works fine with FoxPro 2.5 tables.
1. Right click on database window and choose Link tables.
2. In Files of Type choose ODBC()
3. Click on Machine Data Source tab.
6. Select Microsoft Visual FoxPro Driver and click Next and then Finish.
7. Type in datasource name, choose Free Table Directory, specify Path then click OK
8. Click OK
I tried that. After I follow all the steps, I get the Link Tables window but there are no tables displayed to choose from. But if you say you got it to work, there must be something I'm doing wrong. Can you verify for me the name and version of the visual foxpro odbc driver?
name = vfpodbc.dll
ver = 6.01.8629.01
date = 9/21/99
Thanks for your help, I got it working. It turns out the reason why tables did not display in the Link Window was because there were too many .dbf's in the folder. It was taking too long to load all their data dictionaries.
I was able to quickly link .dbf's using code. Again thanks.