View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MrsButtersworth MrsButtersworth is offline
external usenet poster
 
Posts: 1
Default 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