SUBSCRIPT ERROR

[bregal]

I have recently been upgraded to OFFICE 2007. I am trying to import data from
an excel spreadsheet into a table in access. I keep getting the error message
"subcript range out of range"

I have tried to do the followoing: save the data to be imported only in
another spreadsheet; save the data as a CSV file; deleted columsn before and
rows after the data to be imported....no luck.

any help?

 

[Gina Whipp]

Bregal,

Several reasons for this... 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.
So going to need a little more information...

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...)

--
Gina Whipp

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

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

 

[Sarah Beth]

I have also recently upgraded to Office 2007 and I am getting the same error
message "subscript out of range". Mine only occurs when I am appending data
into an existing table in Access. I successfully merged these same files in
Access 2003 last month. Also, they were originally one file - I just split
them up and now want to put them back together. I have not changed the field
headers or types or anything. They are exactly the same files with just
different data in them. If I try to import these files into a new table I
have no problem. I am really confused.

 

[Gina Whipp]

Sarah,

How many columns in the new table and how many columnc are appending to.
Also, did you check out the items in my previous posting?

--
Gina Whipp

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

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