View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Macro/Method of Importing DATA in a loop

If all text files are of the same format (field structure); from command mode
copy the files into a single file. For example if you have your files placed
in c:\temp\

From command line use the copy command to merge the files to a single
file...and then open the merged.txt in excel...

c:\temp\copy *.txt c:\merged.txt/b


If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

I have received around 280 text files with delimiters to be imported in a
single excel file.

Any idea, How to start the exercise in a looping manner or together ,
instead of opening each and every separately?
--
Best Regards,

Faraz