Text file import / remove lines

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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
 
Back
Top