Importing External Data From Several Files

[Eric O'Connor]

I have a folder full of *.CSV files, and I'm able to import them into a
workbook by using the Import Data command, but this only imports a single
file at a time. I would like do import all of the csv files without having to
import each one.

 

[Dave Peterson]

Into the same worksheet?

See Ron de Bruin's site:
http://www.rondebruin.nl/csv.htm

 

[Eric O'Connor]

Yea, there are 55 CSV files in one folder that I would like to import into
one worksheet.

 

[Dave Peterson]

Then see Ron's site.

Yea, there are 55 CSV files in one folder that I would like to import into
one worksheet.