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 ??