Results 1 to 6 of 6

Importing from Excel

  1. #1
    Jishnu Surendran is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2018
    Posts
    29

    Importing from Excel

    I have an access table with lookup columns. I tried to populate the table by importing from Excel. Although the values in the look up column and my excel file match, it shows 'subscript out of range error'. Why does that happen?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    44,223
    Post the code for analysis.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  3. #3
    Jishnu Surendran is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2018
    Posts
    29
    Error code?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    44,223
    The code you are running to do the import. The code that is failing.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  5. #5
    Jishnu Surendran is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2018
    Posts
    29
    I'm not using a code. It is done directly from external data option in access. The look up columns are not populating and causing the subscript out of range error.

  6. #6
    AdrianG001 is offline Novice
    Windows 10 Access 2007
    Join Date
    Mar 2018
    Posts
    6
    Hey,

    Here is the perfect solution for you. Please refer the below guide

    support.office.com/en-us/article/exchange-copy-import-export-data-between-excel-and-access-409c27cc-c69d-461d-a74c-35392a68ed53#bmwork_with_excel_data_in_access

    Adrian Gates
    Sr. Cloud Expert - CloudDesktopOnline

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

Similar Threads

  1. Replies: 1
    Last Post: 04-10-2017, 09:06 AM
  2. Importing From Excel
    By Emma35 in forum Forms
    Replies: 2
    Last Post: 03-11-2016, 06:44 AM
  3. Replies: 10
    Last Post: 12-28-2012, 01:06 PM
  4. Importing Excel
    By Palhay in forum Import/Export Data
    Replies: 1
    Last Post: 08-08-2012, 05:15 AM
  5. Need Help about importing from Excel
    By Nicc V in forum Access
    Replies: 6
    Last Post: 12-12-2011, 02:11 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