Results 1 to 11 of 11

Thread: Problem importing excel spreadsheet into Access

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Jul 2007
    Posts
    71
    Location

    Problem importing excel spreadsheet into Access

    I'm getting this error:

    "Field 'F1' doesn't exist in destination table 'tblImport'"

    I am using this command:

    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblImport", filename
    filename is a variable containing the full path and filename of the file to be imported. This module imports all files in a certain directory.

    If I use this command:

    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblImport", filename, True
    It will work, but I have to of course put the field names in the first row in excel. I want to just have raw data, no field names. Am I doing something wrong?
    Last edited by Aussiebear; 04-02-2025 at 09:53 PM.

Posting Permissions

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