Archive of Mr Excel Message Board

Back to Lotus archive index
Back to archive home

Merging CSV files in Excel

Posted by Mark Ormiston on February 12, 2002 2:50 AM

I have multiple .CSV files which I exported from a database. The database limited me to export a max of 1000 records. Is there a way I can merge all these files together in Excel to creat one master file?

Thanks

Re: Merging CSV files in Excel

Posted by Mark W. on February 12, 2002 7:58 AM

I'd append the files using a system editor.
Try BBEdit on the Mac or EditPlus on Windows.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.