subscript out of range

[philfer]

Hello,

When I try to import a sheet from Excel into an existing table I get a subscript out of range error.

When I then import the sheet into a new table and then import it into the existing table I was trying above immediately afterwards it works fine

What a mystery?!?!!?

Anyone ever seen anything like this before

Cheers

[mrojas]

Are there any invalid characters in the column headers? Could you attached sample of Excel file in question?

[SamT]

I know Access like I know the back of YOUR hand :)

Are the Column Header labels identical to the Access Field names? :dunno if it makes a difference, but...

[mrojas]

I've run into this problem before, and to the best of my recollection, it had to do with column headers; thus my question. It might be that there's a column without or a duplicate column header.

[SamT]

IIRC, you can name an Excel Range "Database",and use DB functions and methods on it and the labels are considered Field names.