vb script using import skips first record in text file 1

[barny2006]

i have this code, which works perfect (thanks to you guys). however, after counting the records/rows imported, i noticed that when i import the text file using access user interface, it imports all records (144). but when i import using this code below, it skips the first record, and imports 143. any idea what could cause this?

Set appAccess = CreateObject("Access.Application")
db_path = "c:\stel\load_db\stel.mdb"
appAccess.OpenCurrentDatabase db_path
appAccess.DoCmd.TransferText 1, "spec1", "tbl1", "c:\stel\stel.txt", True

 

[Swi]

That is because you have the [HasFieldNames] parameter equal to True. Set it to false if you do not have a header record. That should work.

Swi

 

[barny2006]

that explains it. thanks so much.