Text file import / remove lines

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?
 
G

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import text file 11
Importing Text Files Into Access 1
transfertext delimited 1
French characters do not import 1
Import Text File Into Access 0
Import text file merging first 2 lines as column headings 1
Parsing Text file and import into Access Table. 13
Importing huge text files 13

Top