Subject: RE: Excel Expert please...I think I found a command which would help... do you know how to open the command prompt in windows? 1) Put all the CSV files in a single directory.
2) Start... Run... then type "cmd" 3) Change to that directory. 4) At the prompt, enter this... for %f in (*.csv) do type "%f" >> allFiles.csv Hit enter... the result should be one large CSV file (allFiles.csv) with the content from all 70 of them. You could then import that CSV into Excel. Edited by newleaf 2007-10-18 8:44 AM
|