how to upload excel in sql server databae using c#

Posted by Shanky11 under ASP.NET on 2/17/2015 | Points: 10 | Views : 362 | Status : [Member] | Replies : 2
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local

above error is coming when i m trying to upload excel sheet in server.
but it works fine

string constr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + uploadedFile + "';Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";




Responses

Posted by: Bandi on: 2/17/2015 [Member] [MVP] Platinum | Points: 25

Up
0
Down
refer
http://www.codeproject.com/Tips/417397/OLEDB-Provider-is-Not-Registered-on-the-Local-Mach

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: A2H on: 2/22/2015 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Please try the solution suggestd in below link

http://www.connectionstrings.com/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine/

Thanks,
A2H
Please mark my reply as answer if it helps to resolve your problem

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response