Good Morning/Afternoon/Evening,

I am currently working on a solution for auto importing text files into access. Currently I am doing the data entry by hand, however given the volume of data entry I have to do, this is conflicting with other responsibilities. I have some experience with BASIC (just getting started with VB) though it's been a few years since I've done anything. I'm not necessarily asking for anyone to write the code for me, mostly just need a nudge in the right direction =)

The files I am working with are delimited, however not in a typical row/column structure, and include a multi line header. I do want some data from the header, but that isn't high priority for me. The rest of the file is structured in the following way:
Each line is delimited, the first field indicates which table the information belongs in. Each line is ended with a double delimiter.
The first line includes identifying information (as an example we'll say customer ID and order ID). All subsequent tables are related back to the customer ID and order ID tables.

The file would basically look like this:

[Header]
[Header]
[Header]
Order,Bob22,May,12345,,
Product,stringcheese,27,$1.99,,
Product,calendar,1,$5.99,,
Service,extendedwarranty,1year,$20.00,,
Service,24hourtechsupport,1year,$30.00,,
Shipto,12345 Q St.,Somewhere,NY,14141,,
End,,

The fields above just signify the formatting being used. I am mainly unsure how to send each line to it's respective table and ensure it is linked back to the Customer and Order tables.

An example table would be the product table:

Item - Quanitity - Price - Customer ID - Order ID

Any help would be greatly appreciated.