I just installed Access 2007 and can't import an excel spreadsheet.

At the end of the Wizard import sequence, it fails with a message "subscript
out of range"

After installing I downloaded and applied what i thought was all the updates.

I'm getting the same problem, trying to append an Excel worksheet to an
existing table. I tried stripping the data of any extras, copying my
original worksheet and pasting in a new sheet as values, but that did not
cure the problem.

Anyone have insight as to what "Subscript out of range" means in plain
English?

"Ed" wrote:

> I just installed Access 2007 and can't import an excel spreadsheet.
>
> At the end of the Wizard import sequence, it fails with a message "subscript
> out of range"
>
> After installing I downloaded and applied what i thought was all the updates.
>
>

Deborah,

Several reasons for this for that particular error message... Could be the
Excel spreadsheet has too many columns, could be there is some corruption in
the Excel spreadsheet, could be the way Access is translating your columns
in Excel, could be there are calculated fields in Excel that Access can't
translate for what ever reason.

Here's some troubleshooting tips...

1. How many columns is the spreadsheet?
2. Do you have any calculated columns?
3. Have you looked at the spreadsheet to confirm there are no errors on the
sheet?
4. Just on a whim here, do you column headings use any reserved words that
might confuse Access?
5. Are you using the wizard or did you write some code? (If you wrote some
code can you post it here?)
6. Have you tried it manually? (You know, File... Import...)

Answers to the above questions might help get to exactly what the problem
is.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Deborah" <(E-Mail Removed)> wrote in message
news:7CD717CB-B6AB-4252-86F1-(E-Mail Removed)...
> I'm getting the same problem, trying to append an Excel worksheet to an
> existing table. I tried stripping the data of any extras, copying my
> original worksheet and pasting in a new sheet as values, but that did not
> cure the problem.
>
> Anyone have insight as to what "Subscript out of range" means in plain
> English?
>
> "Ed" wrote:
>
>> I just installed Access 2007 and can't import an excel spreadsheet.
>>
>> At the end of the Wizard import sequence, it fails with a message
>> "subscript
>> out of range"
>>
>> After installing I downloaded and applied what i thought was all the
>> updates.
>>
>>

What I have found is that the file that is being imported used to have more
rows and/or columns. If you open it and delete any blank rows/columns, you
should be able to import.

"Ed" wrote:

> I just installed Access 2007 and can't import an excel spreadsheet.
>
> At the end of the Wizard import sequence, it fails with a message "subscript
> out of range"
>
> After installing I downloaded and applied what i thought was all the updates.
>
>

This doesn't work. I deleted blank rows and columns, but no luck.

"OEJ29" wrote:

> What I have found is that the file that is being imported used to have more
> rows and/or columns. If you open it and delete any blank rows/columns, you
> should be able to import.
>
> "Ed" wrote:
>
> > I just installed Access 2007 and can't import an excel spreadsheet.
> >
> > At the end of the Wizard import sequence, it fails with a message "subscript
> > out of range"
> >
> > After installing I downloaded and applied what i thought was all the updates.
> >
> >