Import data file into excel 2002

  citylim 09:55 25 Jul 2003
Locked

I have data file in txt format downloaded from the datalogger. i.e (data format :nameDDMMYYYY)
PJ20072003,PJ21072003,PJ22072003,PJ23072003 and so on.

I want to copy the files one day after another by joining the time series from the respective days.
I know we can use copy/paste which we have to open and close each files. .The problem is I have thousand files dated back year 1995!!

Please help me to solve this mess.

Thanks and god bless you.

  VoG II 12:21 25 Jul 2003

click here has macros for importing text files. You may be able to use this as is or modify it to sequentially open, read and close all the text files in a folder.

I am assuming that these are comma delimited records.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment utiliser Live Photos ?