I have about 1000 different text files, is there a way to import them all at once instead of doing each text file one at a time? I dont want to import 1000 different files manually, that would literally take about 10-11 hours.
Thanks in advance!
I have about 1000 different text files, is there a way to import them all at once instead of doing each text file one at a time? I dont want to import 1000 different files manually, that would literally take about 10-11 hours.
Thanks in advance!
If it were mine I would write some VBA code to read the directory and import each file.