I have a csv file that need to im****t to Access database.
The csv carries two types of data: PO header and PO lines. They are in
different format and length, which should be im****ted into two different
tables: tbl_header and tbl_line.
The PO header is customer name, address, etc.
The PO lines are what products are ordered.
The length of header is order type (3), order ID (4), customer name
(20)…
The length of lines are order type (3), order ID (4), line number (2),
item
description (20), qty (2), price (##.##).
In following case John Stewood purchases one wireless mouse worth $15.00
and
one keyboard worth $3.5, order ID are 1000-01 and 1000-02.
Following is the example of csv
HDR1000JOHN STEWOOD
LIN100001WIRELESS MOUSE 1 1500
LIN100002KEYBOARD 1 0350
How to write the codes?
|
