| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.access.modulesdaovba.ado,microsoft.public.excel.programming
|
|||
|
|||
Import csv to different tables
I have a csv file that need to import 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 imported 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How import multiple tables from same web page (Web Query)? | Excel Discussion (Misc queries) | |||
| Import data from multiple tables | Excel Programming | |||
| I can import Access Tables. But, I can't import Access queries | Excel Programming | |||
| Import Queries instead of Tables (ADO) | Excel Programming | |||
| Import Queries instead of Tables (ADO) | Excel Programming | |||
Threaded Mode
