This download will install a set of components that can be used by non-Microsoft Office applications to read data from Microsoft Office System 2010 files.
2 comments
Comments are closed.
Recent Downloads and Articles from the Microsoft Download Center
This download will install a set of components that can be used by non-Microsoft Office applications to read data from Microsoft Office System 2010 files.
Comments are closed.
We have tried to access the excel data through this driver. But this driver is not getting installed properly. As per documentation we have to provide the connection string for ADO as:
“Provider=Microsoft.ACE.OLEDB.14.0; Data Source=abc.xlsx ; Extended Properties=Excel 14.0”
But this connection string is not working. We have our application running with Office 2007 driver very well with following connection string.
“Provider=Microsoft.ACE.OLEDB.12.0; Data Source=abc.xlsx ; Extended Properties=Excel 12.0”
It seems to be an issue while installation of Office 2010 driver. I wasnt able to spot an guid against “Microsoft.ACE.OLEDB.14.0” in the system registry after installation of driver.
We have tried to access the excel data through this driver. But this driver is not getting installed properly. As per documentation we have to provide the connection string for ADO as:
“Provider=Microsoft.ACE.OLEDB.14.0; Data Source=abc.xlsx ; Extended Properties=Excel 14.0”
But this connection string is not working. We have our application running with Office 2007 driver very well with following connection string.
“Provider=Microsoft.ACE.OLEDB.12.0; Data Source=abc.xlsx ; Extended Properties=Excel 12.0”
It seems to be an issue while installation of Office 2010 driver. I wasnt able to spot an guid against “Microsoft.ACE.OLEDB.14.0” in the system registry after installation of driver.