import from text file cont...

[Shawna]

Thanks for the previous reply to the following.

I need to import information from a text file but it

isn't deliminated nicely. i.e. a sales order
The file consists of name and address info, but also the
parts info. Is there a different way to have access

find the right information for the right field/table
besides the standard one row = one record in the
deliminated fomat? Any help is appreciated!

I thought VB code would be involved. There is some
information to go to 2 different tables and some I would
like to not import at all if possible.

A sample of the information is as follow, I put my wish
list as *******************XXXX otherwise there are no
blank lines in the middle of the record.

***************TABLE ONE INFO
"01001","PHOS. LINE 2 2A PUMP","00","P2-2A-1087-
C",2,"316L"
52,182.9428,219,"CS","01-16-2003",0
"1 REVISED DIMS.","02-04","CS"
"2 MATERIAL","03-06","CS"
"No PWHT","No Hydro","5153"
"Priority "
**********WOULD LIKE TO NOT IMPORT
0
0
2
""
""
0
7
*********************START OF TABLE @ INFO
2,"16BAP0****S"
6,"15BAP0****S"
1,"16BRP0"
1,"16BSP0"
1,"16BXP0"
3,"15BRP0"
6,"15BSP0"
"1",279.4,"P16PSIBE","GxB",""
"2",685.8,"P15PSIBE","BxB",""
"3",395.3,"P15PSIBE","BxB",""
"4",481,"P15PSIBE","BxB",""
"5",2,"L15PCB*P1*","",""
"6",1,"E15PSIBW9015","",""
"7",1,"T16PSIBU15B","",""
"8",1,"R16PSIBQ15BBB","",""
"9",2,"A15PSIBC","",""
"END"
"01000","PHOS. LINE 2 2A PUMP","00","P2-2A-1085-
B",3,"316L"
76,157.9179,173,"CS","01-16-2003",0

Your help is appreciated.

(I posted a new message aswell as the above info in a
reply post to my original message - wasn't sure which was
best-I'll look at both areas for reply)