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 Removed)
(E-Mail 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)


"tasha" <(E-Mail Removed)> wrote in message
news:cq4a2l$j95$(E-Mail Removed)...
> 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 Removed)
> (E-Mail 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.
>
>

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


"Bob Phillips" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> See response in .misc
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "tasha" <(E-Mail Removed)> wrote in message
> news:cq4a2l$j95$(E-Mail Removed)...
>> 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 Removed)
>> (E-Mail 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.
>>
>>
>
>

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³:

> 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).
>

Can you pass me that code?

Thanx


"Piotr" <(E-Mail Removed)> wrote in message news:cq4me2$8sk$(E-Mail Removed)...
>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³:
>
>> 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).
>>
>

You could just add code to copy the data in the newly opened workbook to a
composite workbook.

--
Regards,
Tom Ogilvy

"tasha" <(E-Mail Removed)> wrote in message
news:cq4j22$qlf$(E-Mail Removed)...
> 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
>
>
> "Bob Phillips" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > See response in .misc
> >
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "tasha" <(E-Mail Removed)> wrote in message
> > news:cq4a2l$j95$(E-Mail Removed)...
> >> 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 Removed)
> >> (E-Mail 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.
> >>
> >>
> >
> >
>
>

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

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