Forum Discussion
Importing Multiple Text Files
Hi All, Is there a way to import multiple text file in MS access database. I have more than 50 - 60 file every time I need to import in access database.
Do the files always have the same names? Are you just importing the latest version of each text file?
If so, then you can save the file names in a table and loop through the files in turn to import them
OR link the text files instead of importing them - then they will always be up to date
If so, then you can save the file names in a table and loop through the files in turn to import them
OR link the text files instead of importing them - then they will always be up to date
Files names are different.
example :
abc.txt
bs.txt
ddn.txt
73m.txt
hh.txt
Likewise the file name will be.
example :
abc.txt
bs.txt
ddn.txt
73m.txt
hh.txt
Likewise the file name will be.
