The problem is that, at about 1 minute per 1000 records, this takes wayyyy too long to load 500,000 - 600,000 records!
I can load these same records from the text file manually by opening the table in MS Access and going though a wizard to import the data from the text file and it doesn't take very long, (can't remember for sure, but well under 15 minutes).
Is there a way I can emulate loading the data into the table directly from the text file using MS Access? I really can't live with 10 hour loads!
Helllllp! (And thanks).
- Add new comment
- 11 views