microsoft.ACE.OLEDB provider not registerd on local machine

koton usani

Pls i need help urgently. an application am developing is showing 'the microsoft.ACA.OLEDB12 provider is not registered on the local machine. the syntax i used in my code is :

"Provider = Microsoft.ACE.OLEDB12, Datasource = F:\Users\KOTON USANI\Documents\BooksData2.accdb"

)

I have downloaded the access database driver engine, runtime engine from the sugestions given but its still showing the same exception. what am i doing wrong?

am using windows 7 32bit operating system
running vb express 2008
and its really urgent!

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dinkar Chavhan15y ago
if u r used office 2007 then used followed coding?
In this Blog, we will see how to display data from an Excel spreadsheet using ASP.NET. We will connect to a Microsoft Excel workbook using the OLEDB.NET data provider, extract data and then display the data in a GridView.

Let us get started.

Step 1: Open Visual Studio > File > New >Website > Under Templates, click ASP.NET WebSite and choose either Visual C# or Visual Basic as the language. Select a location and click Ok.

Step 2: We will create two excel sheets and add them to the project. One excel sheet will be created in Office 2003(.xls) and the other one using Office 2007(.xlsx). Add 4 columns called EID, EName, Age and City to the 'Sheet1'. Also add some data into the columns. Once these excel files are created, add them to your project. To add them to the project, right click project > Add Existing Item > Add the two excel files.

Step 3: We will now create a web.config file to store the connection string information. Right click project > Add New Item > Web.config. Add the following entries to the file

      <connectionStrings>
            <add name="xls" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Sample1.xls;Extended Properties=Excel 8.0"/>
            <add name="xlsx" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Sample.xlsx;Extended Properties=Excel 12.0"/>
      connectionStrings>

As you can observe, the connection string for xlsx (Excel 2007) contains Microsoft.ACE.OLEDB.12.0 as the provider. This is the new Access database engine OLE DB driver and is also capable of reading Excel 2003.

Step 4: Add a GridView to the Default.aspx page. We will extract data from the excel file and bind it to the GridView.

Step 5: Let us now create a connection to the excel file and extract data from it. Before that add a reference to System.Data.OleDb namespcae;

Code following

{
protected void Page_Load(object sender, EventArgs e)
    {
        OleDbConnection cn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;"+"Data Source="+Server.MapPath("sample.xlsx")+";"+"Extended Properties=Excel 12.0;");
        cn.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select * from [Sheet1$]", cn);
DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds.Tables[0].DefaultView;
            GridView1.DataBind();
}
if u want for this example then search my Blog in C# corner
How to Read Excel Data in Asp.net?
0
Dinkar Chavhan15y ago
First tell me r u used Office 2007? then used this coding

In this Blog, we will see how to display data from an Excel spreadsheet using ASP.NET. We will connect to a Microsoft Excel workbook using the OLEDB.NET data provider, extract data and then display the data in a GridView.

Let us get started.

Step 1: Open Visual Studio > File > New >Website > Under Templates, click ASP.NET WebSite and choose either Visual C# or Visual Basic as the language. Select a location and click Ok.

Step 2: We will create two excel sheets and add them to the project. One excel sheet will be created in Office 2003(.xls) and the other one using Office 2007(.xlsx). Add 4 columns called EID, EName, Age and City to the 'Sheet1'. Also add some data into the columns. Once these excel files are created, add them to your project. To add them to the project, right click project > Add Existing Item > Add the two excel files.

Step 3: We will now create a web.config file to store the connection string information. Right click project > Add New Item > Web.config. Add the following entries to the file

      <connectionStrings>
            <add name="xls" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Sample1.xls;Extended Properties=Excel 8.0"/>
            <add name="xlsx" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Sample.xlsx;Extended Properties=Excel 12.0"/>
      connectionStrings>

As you can observe, the connection string for xlsx (Excel 2007) contains Microsoft.ACE.OLEDB.12.0 as the provider. This is the new Access database engine OLE DB driver and is also capable of reading Excel 2003.

Step 4: Add a GridView to the Default.aspx page. We will extract data from the excel file and bind it to the GridView.

Step 5: Let us now create a connection to the excel file and extract data from it. Before that add a reference to System.Data.OleDb namespcae;

Code following

{
protected void Page_Load(object sender, EventArgs e)
    {
        OleDbConnection cn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;"+"Data Source="+Server.MapPath("sample.xlsx")+";"+"Extended Properties=Excel 12.0;");
        cn.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select * from [Sheet1$]", cn);
DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds.Tables[0].DefaultView;
            GridView1.DataBind();
}
0
koton usani15y ago
hi shashi, i tried exactly that but it was still showing the exception. Any further suggestions?
0
shashi kant 015y ago
Try to change the plateform to x86

Hope this will help :)
0