Subscript out of Range

R

R Tanner

Hi,

I'm trying to import data into Access. I just learned today, but I
have been successfully importing named ranges all morning. I have one
last spreadsheet I have been trying to import, and when I try to do
so, I get a message that says - Subscript out of Range. Any idea
why? All of my column headers match up...Surely I do not have too
much data. I only have about 550 rows in this particular table.

Thanks!
 
R

R Tanner

Nevermind...I figured it out...A datatype was not matching my
designated database datatype for that specific field...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Subscript out of range when importing into access 2010 from excel 0
What causes "Subscript out of range" during Access import? 2
import data from Excel - "subscript out of range" 6
SUBSCRIPT OUT OF RANGE 3
Can't import table into Access. Message "Subscript out of Range"? 0
"subscript out of range" 1
Subscript out of range error 3
"Subscript out of range" 1

Top