| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing a large amount of data using Basic
Hi, I have 16,000 files that need to be imported into an excel spreadsheet. Ideally, each file (with about 100 different variables) would automatically import into its own row. I'm looking for help in creating something that will automatically go through a folder, open each file (comma delimited), and put all the data from each file in its own row. Any help is Greatly Appreciated. -- MrsButtersworth ------------------------------------------------------------------------ MrsButtersworth's Profile: http://www.excelforum.com/member.php...o&userid=23724 View this thread: http://www.excelforum.com/showthread...hreadid=373997 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reformating large amount of data | Excel Discussion (Misc queries) | |||
| Grouping large amount of data by day-of-week | Excel Discussion (Misc queries) | |||
| Changing large amount of Data | Excel Discussion (Misc queries) | |||
| Large amount of data for plotting | Charts and Charting in Excel | |||
| CopyFromRecordset with large amount of data | Excel Programming | |||
Threaded Mode
