• Subscript out of Range (Access XP)

    Author
    Topic
    #442053

    Good Morning,

    I am trying to import an Excel XP spreadsheet with 19 columns and 1326 Rows into a new Access Table. I keep getting a Subscript Out of Range Error message from the Import Spreadsheet Wizard. What could be the cause? TIA.

    Viewing 1 reply thread
    Author
    Replies
    • #1063121

      Is it being imported into an existing table or is it being created anew?

      Is is possible to send your spreadsheet for us to look at?

    • #1063122

      Try this:
      – Select all empty columns to the right of the data in the Excel worksheet, then delete them.
      – Also select all empty rows below the data and delete them.
      – Save the workbook.
      – Try to import again.

      • #1063123

        Greetings and thanks for the quick response. I copied the 19 X 1326 cells with data to a new worksheet and the import worked as I had hoped. Thanks again.

    Viewing 1 reply thread
    Reply To: Reply #1063123 in Subscript out of Range (Access XP)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




    Cancel