Importing Excel

G

Guest

I am importing an Excel file. When I import it, it tells me that my "script
is out of range". What does this mean?
 
K

Ken Snell [MVP]

Likely the error message is "subscript is out of range". This message is a
"generic" one that indicates that the argument being supplied to a
subroutine or function is "out of the range" that the function or subroutine
expects or that it can find (e.g., suppose you have one form open, and your
programming tells ACCESS to open the second form in the collection --
because there is no second form, you'd get this error message).

You don't say how you're importing the file -- are you using File | Get
External Data | Import menu? Or are you using a macro (TransferSpreadsheet
action)? or VBA code (DoCmd.TransferSpreadsheet method)?
 

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

Importing Data From Excel 1
Access Subscript out of range when importing into access 2010 from excel 0
Import Excel 2010 table into Access 2010 - not listed as range 1
Import from Excel - Subscript out of range 2
Problem importing excel with nulls 1
Browse button for access form 1
Import 4 Different Excel Files from One Folder 0
Script out of Range 1

Top