first line in csv file

melona · #1 (**permalink**) 04-15-04, 09:49

Hallo!
I’m trying to import a csv-file to Access2k through VBA. I have the problem that it’s just ignoring the first line, regardless if I say that it contains field names or not. I’m using the specifications ‚ImportSpec’ und the code:
DoCmd.TransferText acImportDelim, "ImportSpec", "tblImport", fname, False
Then with HasFieldNames = false!
I’m using a file with 20684 lines, but I get only 20683 imported.
Does anybody have an idea why it doesn’t work?

melona · #2 (**permalink**) 04-15-04, 09:58

sorry, ignore this post!
I've postet it in the wrong forum.
Sorry, guys.

Quote:

Originally posted by melona
Hallo!
I’m trying to import a csv-file to Access2k through VBA. I have the problem that it’s just ignoring the first line, regardless if I say that it contains field names or not. I’m using the specifications ‚ImportSpec’ und the code:
DoCmd.TransferText acImportDelim, "ImportSpec", "tblImport", fname, False
Then with HasFieldNames = false!
I’m using a file with 20684 lines, but I get only 20683 imported.
Does anybody have an idea why it doesn’t work?

Internet Services

Web Development

Digital Marketing

Consumer Tech