Hi, hoping someone can help me with a ridiculous problem I am having in Access.
I have a 2003 database that links to an 2003 Excel Spreadhseet. The spreadsheet is passworded to modify but anyone can open it to read it but not modify it.
Inexplicably, I now get an error message in my database when I try to open the linked table. The message that comes up is "External table is not in the expected format".
The Excel table has been linked into the database for over a year without any problems but all of a sudden this message appears. If I open the spreadsheet, with the password, I am then able to open the table and/or run my queries in the database.
Nothing has changed with the spreadsheet, ie column names have remained unchanged, format has always been Excel 2003 etc so I am at a complete loss as to why this has started to happen.
Any feedback you can give would be much appreciated.
Thanks
I have a 2003 database that links to an 2003 Excel Spreadhseet. The spreadsheet is passworded to modify but anyone can open it to read it but not modify it.
Inexplicably, I now get an error message in my database when I try to open the linked table. The message that comes up is "External table is not in the expected format".
The Excel table has been linked into the database for over a year without any problems but all of a sudden this message appears. If I open the spreadsheet, with the password, I am then able to open the table and/or run my queries in the database.
Nothing has changed with the spreadsheet, ie column names have remained unchanged, format has always been Excel 2003 etc so I am at a complete loss as to why this has started to happen.
Any feedback you can give would be much appreciated.
Thanks