Results 1 to 4 of 4

subscript out of range

  1. #1
    philfer is offline Novice
    Windows XP Access 2007
    Join Date
    May 2010
    Posts
    3

    subscript out of range

    Hello,

    When I try to import a sheet from Excel into an existing table I get a subscript out of range error.

    When I then import the sheet into a new table and then import it into the existing table I was trying above immediately afterwards it works fine

    What a mystery?!?!!?

    Anyone ever seen anything like this before

    Cheers

  2. #2
    June7's Avatar
    June7 is online now Moderator
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    31,239
    Would have to examine the source file if you want to provide.
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    philfer is offline Novice
    Windows XP Access 2007
    Join Date
    May 2010
    Posts
    3

    subscript out of range

    Quote Originally Posted by June7 View Post
    Would have to examine the source file if you want to provide.
    Hi,

    Id like to but it has sensitive data in it and I'd get into all kinds of trouble if I did!!!

    Its really a strange one as if I get this error I just import it into a new table and ti works fine. Then I import it into the table I was trying immediately before when I got this error and then it works fine.

    If I rename the new table that was created above to the original table name the next day I get the same error!!!

    Go figure

    Cheers
    Phil

  4. #4
    June7's Avatar
    June7 is online now Moderator
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    31,239
    Don't need your actual data, dummy data would be fine. I have to be able to replicate issue in order to analyse because never encountered this before.
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

Please reply to this thread with any new information or opinions.

Similar Threads

  1. subscript out of range error
    By adray13 in forum Import/Export Data
    Replies: 4
    Last Post: 05-24-2013, 01:26 AM
  2. Replies: 4
    Last Post: 02-13-2013, 12:35 PM
  3. Replies: 3
    Last Post: 02-01-2013, 10:26 AM
  4. Subscript out of range (9)
    By msche398 in forum Programming
    Replies: 1
    Last Post: 07-08-2011, 11:52 AM
  5. Database Split - Error Subscript out of range
    By Huddle in forum Database Design
    Replies: 7
    Last Post: 07-16-2010, 12:52 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
  •  
Tech Forums: Microsoft Office Forums