Bulk copy excel data to sql database using Asp.Net

Sangam Singh

10y906.NET

I am getting this error while trying to copy excel data to sql database
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Source Error:

2 Replies

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

Vinay Singh10y ago
Please change the connection string as shown below
public string connectionstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\bookstore.mdb;Persist Security Info=False;";

For detail check the link

http://www.aspdotnet-pools.com/2014/06/binding-gridview-by-access-database.html
0
Midhun Tp10y ago
Hi, please check below links- http://www.mikesdotnetting.com/article/280/solved-the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine http://stackoverflow.com/questions/6649363/microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine
0

Bulk copy excel data to sql database using Asp.Net

I am getting this error while trying to copy excel data to sql databaseThe 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

I am getting this error while trying to copy excel data to sql database
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.