asked on

Excel 2010 Could not find installable ISAM

Hi All,

I have an excel workbook which pulls in data from multiple access databases.

The document was created on my laptop and has worked for 8+months however I am now unable to refresh the data from access and get an "Could not find installable ISAM" error.

The document can be opened on other computers and runs without issue so its not a problem with the connection string, I also have full access to the files (direct through access).

Excel is v 2010 32 bit running on Win 7 x64 - I recently ran windows update so Im not sure if something in there may have broken it and I have tried a detect and repair on office with no luck.

Any ideas other than format/reinstall?

Thankyou
Paul

[ fanpages ]

Hi,

Please can you quote the Connection String you are using?

Thanks.

BFN,

fp.

bentbris

ASKER

ConnString is (the .xpa file extension is a renamed mdb used for an accounting package).

As mentioned both machines use the same connection string but the other doesn't have the issue - Forgot to mention that other machine is win xp with office 2010 32 bit.

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=U:\AUDIT.XPA;Mode=Read;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False

ASKER CERTIFIED SOLUTION

[ fanpages ]

membership

This solution is only available to members.

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

Start Free Trial

bentbris

ASKER

Looking at that today (windows updates) and Ive discovered that my 2010 office does not have SP1 installed so I will check that too (just incase).

Yes the file extension has remained constant.

bentbris

ASKER

Thankyou - Rollback of windows update has fixed my issue - ill ensure office is up to date and try the windows update again when I have time.

Thankyou
Paul

[ fanpages ]

You're welcome, Paul.

Hopefully you can establish which of the elements of the latest Windows Update caused the issue & just elect to remove that from the list on the next occasion.

Good luck!

BFN,

fp.