Category: ASP.NET

20 Jan 2017 12:17

Joined:	13/03/2015
Level:	Silver
Points:	144

Points:	2

Upload excel data in sql using asp.net

hi every one,

i upload excel data in sql.is it work in local but when host in server it showing error.
please solve this i try many times but didn't get.

Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Thanks and regards

#768737

20 Jan 2017 13:21

Joined:	18/12/2008
Level:	Gold
Points:	2921

Points:	2

Hi,

You need to install Microsoft Office in the server.
For Microsoft.ACE.OLEDB.12.0 we need to install the this office in the server. This version of DLL will be available in the Microsoft 2010 version,

Thanks,
Mani

#768738

20 Jan 2017 14:25

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	2

Hi

I am also facing this issue . So that i download and install following url. but still now i facing that issue
any one guide me. for Microsoft 2010 version not working

https://www.microsoft.com/en-us/download/details.aspx?id=13255

Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com

'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

#768739

20 Jan 2017 14:35

Joined:	28/04/2006
Level:	Gold
Points:	29773

Points:	2

Hai Sadiq,
You need to install the driver for the Microsoft MS Access into the server machine as well and then only it will work. As the driver is not present in the server machine, you are getting this type of error message.
Hope it will be helpful to you.

Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com

#768749

23 Jan 2017 08:32

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	3

Hi Saidq,

It's looks like bit format issue, you have to install the appropriate drivers suitable for your server machine bit either 32 or 64.

I guess you are implement the task without knowing the server configurations, whether server supports your implementation or not first check that, because you used all are advanced versions like drivers etc, it may not work in lower version please check those.

Hope this helps you..

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

#768790

31 Jan 2017 06:19

Joined:	30/04/2012
Level:	Gold
Points:	7233

Points:	3

You need to install particular supporting driver of for the Microsoft MS Access into the server machine to Upload excel data in sql using asp.net .
Reference for how to upload or import data from excel to SQL Server using asp.net => http://www.aspdotnet-suresh.com/2012/12/c-importupload-data-from-excel-to-sql.html

Upload excel data in sql using asp.net

About dotnetspider.com

Quick Links

General

Services