Results 1 to 3 of 3
  1. #1
    Ant_Snell is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2021
    Location
    UK
    Posts
    118

    Subscript out of range


    I have created an import button that runs a number of "Saved Import" processes. it has been working fine but as started to error today, therefore I deleted the saved imports and have attempted to re-create them. On one files (Excel.xlsx) I get a 'Subscript out of range' but have no idea what this is telling me. As far as I can see the file location and file names and format have not changed. Any advise to find the problem please

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    message implies that a value is too big to fit into the destination field. Might be text longer that 255 chars, might be a number is greater than 32,767 or less than -32,768 if destination is integer for example

    you will need to check all the cells in your excel file meet the destination requirements. Typically way to do this manually is to sort on each column one at time and check first and last record. For text, create a temporary column to return the cells length

  3. #3
    Ant_Snell is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2021
    Location
    UK
    Posts
    118
    Ajax, Thanks yes that makes sense. Ta

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

Similar Threads

  1. Subscript out of range
    By wpryan in forum Forms
    Replies: 2
    Last Post: 11-19-2015, 11:18 AM
  2. Sometimes get subscript out of range
    By khughes46 in forum Import/Export Data
    Replies: 8
    Last Post: 06-13-2014, 10:22 AM
  3. subscript out of range
    By philfer in forum Access
    Replies: 3
    Last Post: 08-17-2013, 01:22 PM
  4. subscript out of range error
    By adray13 in forum Import/Export Data
    Replies: 4
    Last Post: 05-24-2013, 02:26 AM
  5. Subscript out of range (9)
    By msche398 in forum Programming
    Replies: 1
    Last Post: 07-08-2011, 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
  •  
Other Forums: Microsoft Office Forums