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.
Code for bulk importing .txt file into seperate records same table
- Thread starter eddyc
- Start date
- Local time
- Today, 23:34
- Joined
- Jul 9, 2003
- Messages
- 17,473
Do the file names have an ascending number system?
Like:-
edc_1.txt
edc_2.txt
edc_n.txt ?
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.
Similar threads
