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

 

[Pat Hartman]

No. If you have a non-standard file, you'll need to create your own VBA code to import it manually. You'll be able to bypass records as necessary.

 

[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