importing multiple text files into excel???

  • Thread starter Thread starter tasha
  • Start date Start date
T

tasha

Hi,

I am experiencing a big problem. As a part of my analysis for PhD I have to
analyze more then 1000 files. The data that I have is in text files. To be
more precise, I have 5 different data sets, from different meteo centres,
each centre has a data set of 365 files for each day during the year. The
format of text files is something as following:

Camborne Met. Office
WINDS rev 4.1
50.20 -5.30 88
02 01 01 00 00 23 0
29 3 35
07:09 (3.0) 07:09 (3.0) 06:08 (3.0)
284 284 65 65 400 400 23 23
12.5 12.5 1 1500 1500 35 35 400 400
43 90.0 43 74.5 313 74.5
HT SPD DIR Radials...
0.101 9.8 113 0.0 0.9 -2.4 9 9 6 16 14 9
0.159 11.7 119 0.1 0.8 -3.0 9 9 6 16 13 9
0.217 12.2 118 0.0 0.9 -3.1 9 9 7 14 9 4
.....

Each text file has in addition data for 30min interval for each day. So at
this point you can realise how much data that is to play around.

My questions would be:
1. How to import multiple text files into excel worksheet. At least 365
files (for one center) at once.
2. After importing is it possible to get rid of the headers between each
data set for specific days. As shown above headers occupy first 10 rows of
each reading, and are separated by $ sign.

Thank you so much!

This is really a huge problem I am experiencing and needs ASAP solution.

Tasha


--
_______________________________________________
Tamara Pejovic

reply e-mail(s): (e-mail address removed)
(e-mail address removed)
_______________________________________________

NOTICE! THE CONTENTS OF THIS ELECTRONIC COMMUNICATION ARE
CONFIDENTIAL AND PROTECTED UNDER COPYRIGHT. USE BY ANYONE
OTHER THAN THE LISTED RECIPIENT(s) IS STRICTLY PROHIBITED.
 
See response in .misc


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Thanks Bob,

I've seen this post today, however it doesn't help me much. I have at least
30 or 365 docs to import (depending do I wanna import yearly or monthly
data).

This code is opening every txt file in a separate worksheet which is not
what I am looking for.

Any other suggestions?

Thanks

Tasha
 
I do like that:
I have macro which import data into access in separate tables, I do have
always 5 different txt files, after importing macro run query which add
fields from 5 tables into one table, then its easy to export this to xls
format.

U¿ytkownik tasha napisa³:
 
Can you pass me that code?

Thanx


Piotr said:
I do like that:
I have macro which import data into access in separate tables, I do have
always 5 different txt files, after importing macro run query which add
fields from 5 tables into one table, then its easy to export this to xls
format.

U¿ytkownik tasha napisa³:
Click to expand...
 
You could just add code to copy the data in the newly opened workbook to a
composite workbook.
 
U¿ytkownik tasha napisa³:
Can you pass me that code?
Click to expand...

This is simply macro
Firstly you have to import manualy and save the import specification
(File->import)
Then you have to use macro ther is Import txt function where you have to
specify file location, specification and table where data will be saved
 
Back
Top