import CSV

[shank]

I have 100 CSV files with a couple lines of data each.
All CSV files have the same columns, etc.
I have to open all and cut-n-paste into one sheet.

What's the quickest way to get this done?

thanks

 

[Dave Peterson]

Ron de Bruin has lots of code that deals with CSV files.

This sounds like it might do what you want:
http://www.rondebruin.nl/csv.htm

If it doesn't, you may want to snoop around Ron's site for a macro with a better
fit.

 

[Bob I]

One way is to use the operating system to copy/concatenate them into a
single file and then load that. You will need to delete the extra 99
header rows after loading.