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?
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?
Post the code for analysis.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Error code?
The code you are running to do the import. The code that is failing.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.
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