View Single Post
  #1  
Old December 25th, 2007, 05:02 PM posted to microsoft.public.access.queries
senthil
external usenet poster
 
Posts: 24
Default Collating text files

Hi,

There are 3 text files - text1.txt, text2.txt, text3.txt. Each of these
files have a records of 10 digits each.

Text1.txt Text2.txt Text3.txt
1234567890 0123456789 1234506789
9638527410 9876543210 4567891230
2583691470 7538694210 9516238470

I want to have a consolidated (txt file or table) with these numbers and
their filenames as below.

Field1 Field2
1234567890 Text1
9638527410 Text1
2583691470 Text1
0123456789 Text2
9876543210 Text2
7538694210 Text2
9516238470 Text3
4567891230 Text3
1234506789 Text3

Any idea...pls help