Import data from DBF files

J

Jacques

What's the best way to import a large dbf file into Access (records from a
DBase file)?

I have one dbf that has over 220,000 records in it. It gets to about 75%
and says "The search key was not found in any record."

Everything is patched to the max (Windows, Office, Jet, etc). This doesn't
happen with any other dbf file, but they are all smaller.

Also, oddly, I can copy and paste 50,000 records in a shot and paste them
through a query, but I don't want to keep doing that for every large dbf I
have. The Access tables have no problem holding the data, just transferring
them seems to be an issue.

Any thoughts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

damaged records in .dbf file 0
Foxpro data to Access 97 1
Import of DBF shows wrong chars 2
Import from BDF files 1
EXCEL 2007 - export to dbf files 0
Import a dbf database into existing access table? 2
How to import .DBF file into ACCESS 8
Importing .dbf File Into a Table Using Macro 1

Top