Script out of Range

G

Guest

I am just using the import wizard to bring in an Excel file into an existing
table in my Access database. This excel file has about 10K of records
however before it finishes, it gives me this script out of range error. is
there a maximum number of records it can import? or is it my data types are
not matching?
 
J

John Nurick

Do you mean "script out of range" or "subscript out of range"?

If the latter, try one of the following:

-Define a named range on the Excel worksheet including all and only the
table you want to import, then select the range name in the import
wizard.

-Delete (or use Edit|Clear|All) all the rows and columns in the
worksheet except the area you want to import.
 

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
subscript out of range 7
Total Number of Records Allowed 1
Subscript out of range 2
subscript out of range 1
How do I deal with the "subscript is out of range" message. 4
Import new data and replace old data in Access table. 4
Import Spreadsheet Wizard Subscript out of Range 0

Top