| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import multiple CSV files into one Excel file
I have roughly around 2000 CSV files (each file is in the range of
49bytes-3MB, a total of 35MB). I would like to import each CSV file to an individual sheet in Excel workbook using Perl OLE. Can I do this? Currently, I am open up each CSV file, copy & paste to a new workbook. This take atleast 40 minutes using Perl OLE. I was hoping to find a better approach to reduce the time. Thanks a lot. -- Slickuser |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Multiple XML Files into Excel | Excel Discussion (Misc queries) | |||
| How to import multiple csv files in single excel file automaticall | Excel Programming | |||
| Import data from multiple txt files into one xls file | Excel Programming | |||
| import multiple files to excel | Excel Programming | |||
| Import of multiple .CSV files into Excel | Excel Programming | |||
Threaded Mode
