| Expert 8TB |
Hi All,
I am stuck with this teeny weeny problem that i cannot import a FoxPro 2.5 dbf file into my MS Access 2003 database.
I dont see any default ODBC driver installed for FoxPro in my ODBC panel but i am sure that there is a very simple and straight forward way to import this file.
Should i use the Visual FoxPro driver in this case? or should i download and install something like some version of MDAC??
Any help would be tremendously appreciated
To import data from a FoxPro database, use the Microsoft Visual FoxPro ODBC driver. To do so, follow these steps: - Click Start, and then click Control Panel.
- In Control Panel, double-click Administrative Tools.
- In the Administrative Tools window, double-click Data Sources (ODBC), and then add a new ODBC data source for your FoxPro database or tables by selecting the appropriate Visual FoxPro driver.
- Start Access, and then open your Access database.
- On the File menu, point to Get External Data, and then click Import.
- In the Import dialog box, click ODBC Databases in the Files of type list.
- In the Select Data Source dialog box, click the Visual FoxPro data source that you created in step 3, and then click OK.
- In the Import Objects dialog box, click the tables that you want to import, and then click OK.
| |
