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

What causes "Subscript out of range" during Access import? 1
Dumb question alert! What program to use? 0
import data from Excel - "subscript out of range" 6
Subscript Out of Range 0
SUBSCRIPT OUT OF RANGE 3
Can't import table into Access. Message "Subscript out of Range"? 0
Word macro that can call cells out of Excel for a find and replace 0
Need Help with a VBA subroutine 0

Top