Text file import / remove lines

[Guest]

Hello:

I am trying to import text delimited file produced by external system.
This file contains data starting from row 10, first 9 rows contain some
tiltes and blank lines. If I remove first 9 rows, my import works perfectly.

How can I have data imported from that file starting at row 10 and
programatically remove first 9 lines? I don't want users to edit that file
manually.

I would appreciate your assistance or thoughts?

 

[Guest]

The TransferSpreadsheet wont do that for you. You could write some VBA code
to open the file, read it in line by line, then do what you want with it.

 

[Ken Snell [MVP]]

see reply in externaldata ng where you also posted this question.

 

[Guest]

I believe I got it imported as text file into table - so maybe I just need to
have programatically to delete first 9 lines from Access. Thanks