Link to home
Start Free TrialLog in
Avatar of leachj
leachj

asked on

How do I import a .dbf table into access 2007?

I have a .dbf file that was exported from a third party program.  I cannot import it into access 2007.  It imports fine into access 2003.  I can open excel 2007 and do a file open and select dbase .dbf file type and it imports fine into excel.  I get an error message in access 2007 "You cannot use ODBC to import from, export to, or link an external Microsoft Access or ISAM database table to your database."  Is there a way to do this?

John
Avatar of gplana
gplana
Flag of Spain image

Try to do a "repair and compact database" after opening from Access-2003. You can also try to use the "save as a prior format".

Finally, you can install the "Microsoft Office Compatibility Pack for Office-2007" to make office-2003 be able to open (and save!) files in the new .accdb format which is the native format of Access-2007.

Hope this helps. Regards.
Avatar of leachj
leachj

ASKER

I guess I was not clear.  The .dbf is stand alone.  I do not have access 2003 on my machine.  I use access 2007.  I imported the dbf into access 2003 on another machine just fine.  The dbf is exported from a propriatary veterinarian program.

John
Ok, sorry for my misunderstood.

Why don't you convert dbf to mdb from Access2003 ?

Is the .dbf the only format that the veterinarian program supports ? Maybe it supports the standard .csv, from which is easier to import to any database.

Regards.
Avatar of leachj

ASKER

I need a one step solution to get it into 2007.
ASKER CERTIFIED SOLUTION
Avatar of Rick_Wright
Rick_Wright
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of leachj

ASKER

That worked sure enough.  I have been trying to import by right clicking on the table and using odbc.

Thanks,
John