Reply With QuoteI never have to import 10 million records but of course it's gonna take a while... Access isn't designed for stuff that big.
Anyone here work with Access/VB alot? Trying to import a flat file to access table, but it is slow because the file contains 10 million records (maybe not the best solution to import to Access, but we gotta try!).
can't wake up
I never have to import 10 million records but of course it's gonna take a while... Access isn't designed for stuff that big.
I know... but I have to try it, at least. I think there is a way to streamline the update process so I am not writing out 1 record at a time to the table, instead do like 1 update per 1000 or something....Originally Posted by Diff-chan
Old Country Doctor
access isn't the thing you want to have 10 million records in.
drop that shit into a mssql server or something
Posting Permissions
Bookmarks