472,133 Members | 1,148 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,133 software developers and data experts.

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
2 14645
ADezii
8,830 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
pttc
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.

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.