Import data file into excel 2002

  citylim 09:55 25 Jul 03

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 03

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.

iPhone 7 review: a range of small updates add up to an excellent phone

1995-2015: How technology has changed the world in 20 years

How New York’s Stylin’ Seniors became a golden social media campaign

23 Apple Watch tips & secret features: Master your Apple Watch, Apple Watch Series 1 or Apple…