Import PIPE Delimited Multiple Line

[wcotis60]

I need to create printable format from a PIPE delimited text file. The file is something like this:

10|2334|DOE|JOHN|M|12161980|M|123 MAIN ST|OXFORD|MS|38865|...
20|2334|BCBS OF MS|YAQ123456789|...
20|2334|MS MEDICARE|123121234|...
30|2334|09182011|71220|CHEST PA/LAT|38.00|...
10|45678|PUBLIC|JOHN|Q|12161980|M|1 MAIN ST|OXFORD|MS|38865|...
20|45678|MS MEDICARE|234232456|...
30|45678|09182011|71210|CHEST 1 VIEW|28.00|...

and so on.



The records are 'related' buy the second field, which is the patient ID#.
The first 2 characters, "10", "20", "30" indicate what type of information.
10 is patient name and address
20 is patient insurance
30 is charge related

Can Access 2010 import this directly?

A new file is received each day, so I need a way to automate this.

Thanks,

[June7]

Cannot use the import wizard because the lines need to go to 3 different tables. This will require VBA code.