Code for bulk importing .txt file into seperate records same table

eddyc

Registered User.
Local time
Today, 19:15
Joined
Mar 23, 2011
Messages
43
I have 12,000 cvs that i need to get into An access database so i can start to extract email info etc. They are stored in one folder All Cvs under each of their names edc.txt (i have converted them to .txt) i want to create one table with two fields name (taken from the cv filename and contents (taken fromthe contents of the .txt file). Can anyone help me withthe VB code .. i am using Access 2007 i am not a newbie but not very experienced.
 
Do the file names have an ascending number system?

Like:-
edc_1.txt
edc_2.txt
edc_n.txt ?
 
What is the layout of the files? I use at work some coding that writes to a table the list of files in your chosen folder. Once I create an import specification I add this to another looping code which runs through all the file names and imports them one by one onto the table. The main thing here I am uploading csv files which have identical layouts.
 

Users who are viewing this thread

Back
Top Bottom