Bulk copy excel data to sql database using Asp.Net

Question

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:

Vinay Singh · Answer

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

Midhun T P · Answer

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

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.