Multiple data import from text files

[Nils_Junker]

Hi everybody,

I got the following problem:

I need to get data from round about 500 text files.
Problem one is that I just need a part of each text file, (the part I need always stays the same)
Problem two is that I dont have enough time to manually convert all the text files one by one.

The following link shows all the files I want to include in my excel

Index of /climate_environment/CDC/observations_germany/climate/10_minutes/air_temperature/recent/

Also how many lines can i insert in Excel?

If you need further Information, please send me an info!

Thanks for your help!

 

[Nils_Junker]

this is the first thing which pops up if i want to run the code
(fyi)
is this right?

 

[Herakles]

Yes.

Say Yes

 

[Herakles]

View attachment 93652

now this error comes up

You will have to translate for me.

Just download and extract a few to test it.

I just need to know that that part of the process works for you.

 

[Nils_Junker]

You will have to translate for me.

Just download and extract a few to test it.

I just need to know that that part of the process works for you.

this means index out of range

 

[Nils_Junker]

You will have to translate for me.

Just download and extract a few to test it.

I just need to know that that part of the process works for you.

what do you mean by extracting?

so i download for example one zip into the download file i created? and then i run it again?

 

[Nils_Junker]

Yes.

Say Yes

after i say yes this thing heere comes up. i inserted for example $A$6 is this right or do i have to insert something different?

 

[Herakles]

Go to the worksheet containing the list of files and select a range of files with the mouse.

Lets start with A2:A6 to test it.

 

[Nils_Junker]

is this even rightly converted?

 

[Herakles]

It looks like you have pasted the list of files into the worksheet OK.

 

[Nils_Junker]

Go to the worksheet containing the list of files and select a range of files with the mouse.

Lets start with A2:A6 to test it.

yeah i did that and than this error comes up