Text Import - Stripping Question

[Pilly170]

Hi,

Im trying to import a text file automatically into access, but I want to strip the top 3 lines of the text file.

eg. Heres the original text. 5 lines only.
<Start of File>
13;Company Name SOD ;Address 1
CAR041 BacklogOfOrders DATE: 01.10.2003

Branch DocumentCode DocumentNo CustNo
13 OA 708532 12871 Customer1
<End of File>

Any ideas how i strip off the top 3 lines using vba?

Thanks

 

[RickSpr]

When I had a similar need, the only solution I could come up with was using VBA code to read the file, skip the initial lines, and write the remainder to a new file, which I then linked as a text table.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[Pilly170]

ok, how did you get it to skip the first few lines?

 

[RickSpr]

Something like this:

    Open "MyFile.csv" For Input As #1
    Open "MyFile.txt" For Output As #2
    Line Input #1, s
    Line Input #1, s
    Line Input #1, s
    Do While Not Eof(1)
        Line Input #1, s
        Print #2, s
    Loop
    Close #1
    Close #2

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[Pilly170]

a million thanks...