ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Accessing Excel 2007 from Visual studio 2005 on Windows 7 machine (https://www.excelbanter.com/excel-programming/435568-accessing-excel-2007-visual-studio-2005-windows-7-machine.html)

sagars76

Accessing Excel 2007 from Visual studio 2005 on Windows 7 machine
 
I am using the following connection string to access the data on excel 2007
on windows 7 machine with visual studio 2005
public static readonly string JetConnectionString =
"Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=..\\..\\..\\DataMiningUserinterface.xlsx;Ex tended Properties=" + "\""
+ "Excel 12.0;HDR=YES;" + "\"" + ";";
but it is giving me an error that "The 'Microsoft.ACE.OLEDB.12.0' provider
is not registered on the local machine." I installed the driver for Office
2007 components and it still gives me the same error. Please let me know how
I can register these components and read the data from excel.


All times are GMT +1. The time now is 06:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com