467,900 Members | 1,407 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,900 developers. It's quick & easy.

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

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
  • viewed: 14194
Share:
2 Replies
ADezii
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:
  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
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.

Similar topics

3 posts views Thread by viviane lima - * - * - | last post: by
2 posts views Thread by william | last post: by
reply views Thread by Remove Animal from email address | last post: by
4 posts views Thread by Farina | last post: by
5 posts views Thread by Andrus | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.