Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    214

    Unanswered: first recording not importing

    I am using access 2003. I've setup an import specification for a text file to import into a table. It's importing but leaving off the first record. When I setup the import specification, I did so as fixed width because the fields were not defining correct when I used delimited. Could it be that it's thinking that the first record include the field names? If so, how do I rectify this?
    thanks

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    DoCmd.TransferText , acImport, 5, "Table Name", "\\File path\File Name.txt,True"

    The statement True tells Access the file has field headings or False for No headings.

  3. #3
    Join Date
    Jul 2004
    Posts
    214
    Thanks! This Worked for me.

Posting Permissions

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