Multi CSV file import

  • Thread starter Thread starter jrb
  • Start date Start date
J

jrb

I have about 200 csv files that I would like to import into excel.
After figuring out that I can only import 1 file at a time, I am trying
to seek a solution to this time consuming problem. Is there an easy way
to import them all at one time, (all the same layout). Is there a way to
merge them all and import them, or any other solution?

Jeff
 
If the files are in the same folder, I'd use an old DOS command:

Shell to DOS (command prompt):
Traverse to the folder that holds all the *.csv's

copy *.csv all.txt

If you want you can rename all.txt to all.csv--or you can leave it .txt and have
the text import wizard appear when you open the file in excel.

(All the lines in all the *.csv files will be less than 65k????)
 
Back
Top