Help: Import & Integrate Many .csv data files to Excel 2000?
I have over 2000 .csv data files to integrate.
3 files in each group, Columns A, B, & C:
A & B are the same in each set of 3 files.
C has different data in each file.
I need to end up with a data file that combines them into this:
A, B, C1, C2, C3
Is there a way to do this with Excel 2000?
Does anyone know of any software that can do this for me?
Lower priced is better, but I am willing to pay for quality software.
Thanks for your time!
Sheri
Answers & Comments
Verified answer
2000 files? thats a lot of files...and a lot of copy&pasting...and it seems like thats all you need to do.
you should be able to automate it with VBA.
you can ask the question again with more details.
or check with VBAXLMan...i havent seen him here at yahoo in a while, but heres his website.
http://www.file1.net/Default.asp
hope it helps
once you save the excel rfile click the document menu or place of work button based on the version and choose save as. interior the save as option (in 2007 and above click excel workbook). Then click the save as style drop down record and choose csv from the record and the excel sheet would be saved as a .csv rfile.