Importing dbf table (2nd post)

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hi

I just upgraded to Access 2003 and now I am not able to import a .dbf table
into access which I was able to do with Access 2000. What can be done?

Thanks in advance.

Richard
 
I just tried it with 2003 and was able to do it. If you're using the
File|External Data|Import did you select the correct file type in the bottom
so that you can see the dbf files? Did you install the importers when you
installed Access?
 
Hi Wayne

I did select the corect file type. when I select the file and click import,
a message comes up "External table is not in the expected format".

What importers are you refering to??

THanks again

Richard
Thanks for replying.
 
The dbf table is a FoxPro table


Wayne Morgan said:
I just tried it with 2003 and was able to do it. If you're using the
File|External Data|Import did you select the correct file type in the bottom
so that you can see the dbf files? Did you install the importers when you
installed Access?
Click to expand...
 
Hi Wayne

Thanks again

I was just wondering how come I was able to do it with Access 2000.

Richard
 
Hi Wayne

I tried to do add the driver but I was not able to do it. Where do I add it
to? There are a few DSNs... Is there any place where I can get a step by
step tutorial or maybe you could help :)

Thanks

Richard
 
1) Download this file.
http://download.microsoft.com/download/vfoxodbcdriver/Install/6.1/W9XNT4/EN-US/VFPODBC.msi

2) Double click the msi file to install it.
3) Open the Data Sources applet from Administrative Tools
4) Under User or System DSN (I used User since that's where the rest of them
are)
5) Click Add
6) Scroll down and choose "Microsoft FoxPro VFP Driver (*.dbf)"
7) Click Finish
8) For Data Source Name type in FoxPro Files and click Ok
9) Click Ok to close the Data Sources dialog
10) Open your Access database and go to File|External Data|Import
11) Choose ODBC Databases from the file types
12) Choose the Machine Data Source tab
13) Choose Visual FoxPro Tables and click Ok
14) Browse to the table you want to import

I don't have any FP tables to test this on, but I've done it with other ODBC
databases. You can probably get by without steps 3-9, but it would be good
to have it there for future use.

The reason this worked in 2000 is because this driver was installed with
Access 2000, it isn't with Access 2003, but it is available.
 
Back
Top