Script out of range

[Ianw]

Hi All,



I am trying to import a spreadsheet into Access 2007 and I am getting the error message "Script out of Range". Anyone come across this before? Does anyone know what thi smeans?

Thanks

Ianw

[June7]

What method are you using for the import? Post code for analysis. What line triggers the error?

[Ianw]

I am using the spreaddsheet import wizard. I don't know what line triggers the error.

[John_G]

This is admittedly a wild shot in the dark, but - do any of the Excel column headings (if you have any) contain blanks? I recall I had problems with Excel import some time ago, and traced it to blanks.

Are you importing to an existing table? If so, does it have any non-standard field types, like multivalue fields?

Try importing to a new table (i.e. let Access create it) and see if the problem persists.

[Ianw]

Good idea. I'll try that.

Thanks

[JoeM]

Note that importing Excel files into Access can be really flaky at times. Excel and Access try to communicate with each other, and Access tries to "guess" what the format of each field should be (I believe it looks at the first 10 rows of data in making that guess). Unfortunately, sometimes it guesses wrong. For example, let's day that you have a column of entries that look like numbers, but somewhere further down the page, there is a text entry. So Access may be "guessing" that this field is numeric, and then that text entry is causing issues.

Unfortunately, Access often makes it very hard to figure out which record is causing issues. I have spent hours in the past trying to figure out where the error resides. Nowadays, if I experience this behavior, I will look for a few minutes to see if I can locate any obvious errors. If I cannot, then I will export my Excel file to a delimited text file (tab or CSV), and then import that. The beauty there is when importing text files, the Import Wizard is invoked and Access lets YOU determine the format of each field. That usually solves the problem for me.

[John_G]

Another thing you might try is to link to the Excel file with the linked table manager, and then use an MS Access append query to transfer the data to an Access table.