Importing Text from the xth row

[GlennG]

Hello all,

Does Access have a feature that allows text files to be imported from the 2nd line insted of the first ?

Excel provides users with the ability to import text files from the xth line with the "Start Import at row xx".

I just want to skip the first line and import the rest of the file.

Thanks for your time...

 

[mdmilner]

It doesn't have a specific command such as Transfertext that will allow you to do this, although if you use acImportHTML or acLinkHTML it does allow you to specify a specific tablename.

Method I've used in the past is to import the records into a table as text, then walk the recordset identifying what the record is and what to do with it (eventually writing data into other tables)

Most of the time I've done this, I was working with <256 character records, although there isn't any reason why you can't import into multiple string(255) fields and manipulate them all as needed.

Mike