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

leachj
leachj used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.

Author

Commented:
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.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
I need a one step solution to get it into 2007.
In Access 2007, I think you can import or link to dbf files.  

Go to External Data / Import / More, and choose DBase (for dbf files)

Having created a temporary linked or imported table, use this as the source for an append query to add the data to your target table.

Rick

Author

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

Thanks,
John

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial