Inserting large data files into Access database
Posted on 2015-02-10
I receive 5 zip files in a daily basis. each zip file contains other zip files.
When we extract the last zip files we will get 50 text files
these text files contain millions of records, I want to inload these records into access database, then move the text file to history folder.
What is the fastest way to extract the text files from the zip files in one folder, loop in each file, and import the data into access database using VBA.
***speed is important***