MS Access data conversion - Import data from DBF files

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Import data from DBF files

Jacques

2006-02-17, 11:24 am

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?

Sponsored Links