import multiple text files at once

  • Thread starter Thread starter Remco Meeder
  • Start date Start date
R

Remco Meeder

Hi,

I have got 37 text files from a datalogger which I want to import into
an excel sheet.
They are tab delimited files.
Is there a way to automatically import all files and in a way that each
of the imported files comes in another sheet in the workbook.

Remco
 
Remco,

If you have Excel 2002, you can set up queries using Data - Get External
Data - Import. You'll have to do this for each file. If you want to go
through the files automatically (without having to once set up a query for
each), I think you'll have to write a macro. The queries can be set to
automatically refresh each time the workbook is opened.
 
Back
Top