Please Help Me To Solve The MS Access Error Message Subscript Out Of Range

Asked By Eleanor rithi 10 points N/A Posted on - 11/29/2020

Please help me to solve the MS Access error message subscript out of range. I am getting this message when I import an Excel sheet to Access. I am using the 2010 version for both the software.

• Status: Open
• Question Views: 43
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Windows OS
• Question Tags: Access error | error message | MS Access error | MS Access error message

Answered By alexandra barry 0 points N/A #345618

Please Help Me To Solve The MS Access Error Message Subscript Out Of Range

When you are getting MS Access error message subscript out of range, you need to take care of these two things –

Number 1

You can have a maximum of 255 columns in your Excel. If you have more than that, you have to change your Excel sheet.

Number 2

If you have conditional formatting or formulas in your Excel sheet, you have to convert it to plain text/ number, and then you will be able to import the file.

After following these restrictions, if you get the error message, follow these steps –

1. Open the file.
2. Go to the security warnings section.
3. Click on Enable content.
4. Go to the advanced options.
5. For each of the macro, check the enable content for this session option.
6. Click on ok.
7. Restart Access.
8. You will get rid of the error message.

About alexandra barry

Questions
8

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/29/2020
• Question Category: Windows OS