Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    5

    Unanswered: first line in csv file

    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?

  2. #2
    Join Date
    Apr 2004
    Posts
    5

    Re: first line in csv file

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


    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •