TransferText import ignoring the first line

[kriemer]

I am currently importing data using the the "TransferText" method in Visual Basic; e.g., expression.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)

Per the above description, I can either include the first line as a field name, or as data. Is there any way to simply ignore this data row and start the import from row 2 onwards?

Thanks as always

k

 

[kriemer]

Pat,

I couldn't figure out the VBA for bypassing (ignoring) records, BUT I did figure that deleting was almost as good as bypassing.

As the first row of my imported data is always the same I added to my existing VBA code:
DELETE Table.Field
FROM Table
WHERE (((Table.Field)="XYZ"));

Not elegant, but it works.

Regards as always

k