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
leachjAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gplanaCommented:
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.
0
leachjAuthor 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
0
gplanaCommented:
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.
0
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

leachjAuthor Commented:
I need a one step solution to get it into 2007.
0
Rick_WrightCommented:
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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
leachjAuthor Commented:
That worked sure enough.  I have been trying to import by right clicking on the table and using odbc.

Thanks,
John
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.