how to upload excel in sql server databae using c#

Posted by Shanky11 under ASP.NET on 2/17/2015 | Points: 10 | Views : 832 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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'";

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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] Silver | Points: 25

0	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 My Blog Shanky11, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts