Import from BDF files

[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?

 

[Jerry Whittle]

When I've had similar problems, it was often the network that was at fault.
Would you happen to be on a Novell network? There's some know issues.

If you can link to the dbf file, one workaround would be to do an append
query on that data and only append a subset of records at a time. Something
like picking on last names from A-M then N-Z in another query. (Watch out for
bizzare last names starting with a number, special characters, or spaces).