asked on

MSACCESS 2003: getting this wierd message: " Method 'Columns' of object 'IImexGrid' failed "

I'm trying to import from Excel to MSAccess and I'm try to 'link' from Excel to MSAccess. I am getting this wierd error message in MSAccess: Method 'Columns' of object 'IImexGrid' failed

The data in the tabs are simply number columns with descriptions columns, etc. I have carefully ensured that all number columns (containing account numbers - all numeric) are indeed saved in Excel as 'numbers'. I have also put a format where if any account-numbers are only 4 digits, and the field should be 5, that the format is '00000' - so that a 0 is held in front. (I don't know if this is what is causing this error message).

Can you please tell me what the error message means? and - what could be causing it ??

Thank you...

ASKER CERTIFIED SOLUTION

clarkscott

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

R B

ASKER

There may be other objects in other tabs, but not the one I am trying to import. Does MSAccess look at the whole-workbook - and produce this error? - or does it only look at the one tab which I choose to import or link to?

clarkscott

Usually, when you link to Excel from Access you specify the single sheet (tab). Is this what you're doing?

Scott C

R B

ASKER

Yes, I'm only naming one sheet (tab)....

SOLUTION

clarkscott

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

R B