Could not find installable ISAM

Hi I am using excel 2010, my excel file connected to dbf file and excel file has my pivot tables based on the dbf file and once the dbf file is updated I refresh the excel file and all the charts are updated. I opened this file in excel 2016 and saved it , and now I cannot refresh any data in excel 2010 and error message comes COULD NT FIND INSTALLABLE ISAM, looks like the connection string settings are changed and I don't know how to fix them. Please advise what settings needs to be changed so that it can work in excel 2010 Settings are :

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=\svrau085ssm00.oceania.corp.anz.com\khant$\My Documents\SAS\;Mode=Share Deny Write;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=18;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

0
edit delete
are you sure?
asked Tauqeer Khan

0 answers

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions