|
Posted to microsoft.public.access.modulesdaovba.ado,microsoft.public.excel.programming
|
|
|
Import csv to different tables
Thanks, I will have a try and get back to you.
"Alex Dybenko" wrote:
Hi,
here an example from help:
Dim TextLine
Open "TESTFILE" For Input As #1 ' Open file.
Do While Not EOF(1) ' Loop until end of file.
Line Input #1, TextLine ' Read line into variable.
Debug.Print TextLine ' Print to the Immediate window.
Loop
Close #1 ' Close file.
so you need to check what kind of line you are getting in TextLine and then
get required values from it
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
"Angus" wrote in message
...
Do you have example code about LineInput?
I have little experience in upload excel file to access by ADO but didn't
know about LineInput.
"Alex Dybenko" wrote:
Hi,
I think you need to read file line by line using LineInput, check what is
a
type for current line and update appropriate table
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
"Angus" wrote in message
...
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?
|