By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

How to Import FoxPro 2.5 ".dbf" files into MS Access

P: 1
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
Jul 20 '07 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,616
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:
  1. Click Start, and then click Control Panel.
  2. In Control Panel, double-click Administrative Tools.
  3. 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.
  4. Start Access, and then open your Access database.
  5. On the File menu, point to Get External Data, and then click Import.
  6. In the Import dialog box, click ODBC Databases in the Files of type list.
  7. In the Select Data Source dialog box, click the Visual FoxPro data source that you created in step 3, and then click OK.
  8. In the Import Objects dialog box, click the tables that you want to import, and then click OK.
Jul 22 '07 #2

P: 1
Great! it is exactly running as what as I expect!

You are expert!
Jun 6 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.