Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subscript out of Range (Access XP)

    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.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Subscript out of Range (Access XP)

    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?

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subscript out of Range (Access XP)

    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.

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subscript out of Range (Access XP)

    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.

Posting Permissions

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