Text import

[FlakyJake]

I have a text file as below, with over 120,000 records that my client would like to persuse with various search criteria from within Access.

would appreciate views and guides on this. Each record houses address details, one copy, booking details could be numerous and brochure details again numerous. Fields seperated by "," and segmented by "þ" between address, booking, and brochure. Bearing in mind that booking and brochure could have many instances which would be the best way to accomplish this task???

0000388,Active,MR,M,Ball,5 Wave Down,,WHITing,Sussex,so32 1EH,UK,01489 772885,SAME,,Aþ0000388,0105297,Firm,12469,10/08/02,OC,12470,12580,12584þ0000388,Broch BH98,0010884,05/11/97,11/03/98,OC,MAIL4,,Encl 99,,07/10/98,10/06/99,,99CLIENT,,,Broch BH99,0035504,04/11/98,10/11/98,OC,99BROC,,,,Encl MS,,04/06/99,04/06/99,,99C,,,,,Broch BH00,,17/11/99,17/11/99,,97R,,,,,,Encl 01,,31/10/00,31/10/00,,CMAIL3,,,,,,,Encl 02,,20/10/01,20/10/01,,CMAIL3,,,,,,,,Broch BH02,0096836,20/11/01,30/11/01,OC,2002BROREQ,,,,,,,,,Broch BH03,,21/11/02,21/11/02,,02C

 

[KenReay]

Hi

Because you haev mixture of 'record types' in one file, I would say, import the text into a single column table, then write code to parse the resulting table to split out the data you want

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK