Accessing Excel 2007 from Visual studio 2005 on Windows 7 machine

S

sagars76

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;Extended 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem writing an Excel file on server using Microsoft.ACE.OLEDB. 1
Importing .xlsm, .xlsx with OLEDB 5
Export specific fields from access to Excel 0
reading excel 2007 returns 255 columns! 3
Exporting data with vba from Excel to an Access 2007 db with password 8
Problems starting Word from Excel VBA 3
ADO connection to a protected workbook? 3
Excel 2007 connection via oledbconnection 2

Top