Script out of Range

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top