ACCESS 2007, "subscript out of range" what's it mean; how to corre

[apprentice idiot]

In ACCESS 2007, in trying to import from Excel, I get the message "subscript
out of range". what does it mean and how do I go about to correct it?

 

[John Nurick]

This is the first time I've heard of this with Access 2007. It's not
clear what it means in earlier versions but it seems to be associated
with some sort of problem with the worksheet or the data on it.

One thing to try is (in Excel) to copy the rectangular range of cells
you want to import, paste them into a new workbook and save it. Then try
importing from the new workbook.

Another is to save the data from Excel as a CSV text file, then import
from that into Access. If the import errors persist, this may at least
produce more information about them.

On Tue, 14 Nov 2006 15:54:01 -0800, apprentice idiot <apprentice

 

[apprentice idiot]

Pasting the data into a new workbook did not work. Hence I tried with another
list in Unicode text form, which did. I then attepted to introduce the
original data also via Unicode text, only to receive the message "Method
'ExecuteTempImexSpec' of object '_WizHook' failed. The same with other lists.
As this is a one-field table, when I try to import using fixed width, I get
the error message "No current record".
Pleae advise.

 

[John Nurick]

I've never come across that error message, and nor had Google until it
indexed your message. _WizHook is a hidden undocumented part of the
Access object model. _WizHook.ExecuteTempImexSpec doesn't seem to exist
in Access 2003, so I guess it's new to Access 2007. From its name I
guess it's used by the text import wizard. Have you tried importing the
data from a delimited rather than fixed width file.

If you're using a beta version of Access 2007 I suggest you wait until
the final version is released.

 

[apprentice idiot]

Clarification: the first message came when I imported from delimited files;
the second came from fixed width files.
I suppose I shall have to wait then for the final version.

 

[flyerman85]

I got the same error message when importing 2003 excel files, on the
one sheet I had I found when I opened it in excel 2007 one of the cells
has a corrupt name it is possible when it is opening it in
compatibility mode it messes something up. I fixed that one cell then
it imported it fine