Last post Apr 09, 2012 02:33 PM by solarissf
Apr 06, 2012 01:03 PM|solarissf|LINK
I have built a website using web developer 2010 express. And use oledb to connect to excel on users desktop and get the following error message.
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
I've found hundreds of posts on this and it seems most people download something from microsoft and problem fixes. Other people have to set program to compile in 32bit mode.
Problem is everyone on here is using vsexpress and I am using web developer express, and I do not see how to change to compile in 32 bit mode to see if this fixes my problem.
Can someone please offer assistance.
The link below shows more details of how others fixed issue.
Apr 06, 2012 01:44 PM|bbcompent1|LINK
What this error means is you don't have teh OLEDB version 12 drivers installed. Go here and grab the redistributable:
Apr 06, 2012 01:47 PM|solarissf|LINK
thats the weird part, I uninstalled, re-installed, and rebooted... still nothing
Apr 06, 2012 01:49 PM|bbcompent1|LINK
Ok, now that is strange. And you are running this on the local machine in the web dev server right? This is happening on your local machine, correct and not production?
Apr 06, 2012 01:54 PM|solarissf|LINK
I did this in web developer 2010 express. I'm not sure how it starts up. When I run on my local pc, local server it works. When I push it to my webhost and goto the website is when I receive the error.
www.fundinception.com... you might see the error, but it tries to access and excel file on your desktop so it might fail there.... (once you hit USERFORM tab) this is driving me crazy
Apr 06, 2012 01:57 PM|bbcompent1|LINK
Ok, that has to exist on the server fundinception.com or you're going to get that error. chances are it probably isnt so I would recommend getting in touch with whoever runs your web hosting toask if thye would install the oledb 12 driver for you.
Apr 06, 2012 02:00 PM|solarissf|LINK
i'm using godaddy.com... I doubt they would install something for me. Is there a way I can put it on my webhost or it doesnt work like that?
Apr 06, 2012 02:06 PM|bbcompent1|LINK
Godaddy? Oh yeah, they won't install it, they do as little as possible for their paying public. Are you reading this spreadsheet into a gridview or somthing like that? If so, I would turn the spreadsheet into a database table (either Access or SQL) and then
go off of that.
Apr 06, 2012 02:11 PM|solarissf|LINK
The goal is for user to login my website. Hit button, the button will reach out to users desktop and grab a specific excel file. Somehow grab the data... right now it loads into a gridview, then manipulate data. How else can I read excel file from users
desktop with using OLEDB? I tried microsoft.interop.excel... and again... after hours of searching you cannot use this reference unless it is installed on the webhost.
I appreciate your help on this
Apr 06, 2012 02:19 PM|bbcompent1|LINK
the problem is its a limitation being imposed by godaddy itself: (http://support.godaddy.com/groups/web-hosting/forum/topic/using-excel-spreadsheets-on-website/)
"Our hosting accounts do not support accessing information from an Excel Database. If you would like to store information like that, we recommend that you use a database. You can set up a MySQL, MS SQL, or Access database using our various Windows hosting
accounts, however Grid-based Web Hosting does not support Access databases. If you have any other questions regarding your account, please feel free to contact our support teams at the following URL:
One other point to ponder, excel is not a database but this is the type of support Godaddy provides :)
Apr 06, 2012 02:23 PM|solarissf|LINK
pardon my stupid questions as obviously I'm new to this... does this say that godaddy makes it IMPOSSIBLE to grab data from an excel file?
Apr 06, 2012 02:27 PM|bbcompent1|LINK
Yes, that is exactly what it means. You should consider finding a new host that doesn't have such limitations. Contact the hosting provider's support or sales and ask them if they support excel files as a data source using OLEDB 12
Apr 06, 2012 02:29 PM|solarissf|LINK
ughhhh... I just signed up. Before I go about looking for a new host... can you think of a way I can someone convert the excel data to a way that godaddy will let me manipulate it? Still having the user do no additional work?
Apr 06, 2012 02:38 PM|bbcompent1|LINK
The problem is in order to convert the excel to a format that GoDaddy would accept without user work would need to do a conversion via the web server which won't work. You kind of have one of those situations where you are between rock and hard place.
Apr 06, 2012 02:45 PM|solarissf|LINK
UGHHHH. well thank you very much for your help. I'm assuming even if the user had an upload button it would be the same problem. So if I start looking around for another web host... can you please let me know the question I need to ask to make sure they
will work for me? Just want to make sure I am specific before I move hosts.
Apr 06, 2012 03:06 PM|bbcompent1|LINK
Sure, what you need to ask them is if they support Microsoft OLEDB 12 using Microsoft Excel files for importing.
Apr 06, 2012 04:56 PM|solarissf|LINK
ok, last dumb question
I can make the source a csv file instead of excel file... if I want to take the same plan of attack... website grabs particular csv file from users desktop , and uploads data... does that mean I get around my current problem? and if so how do I go about
Apr 06, 2012 04:58 PM|bbcompent1|LINK
A CSV you might be able to work with but the bigger question here is what are you going to do with the file? Are you importing it into the database?
Apr 06, 2012 05:03 PM|bbcompent1|LINK
For examples on how that is done in code, check out these samples:
Apr 06, 2012 05:05 PM|bbcompent1|LINK
And proof that they do support the use of CSV files:
Apr 06, 2012 07:16 PM|solarissf|LINK
awesome... I'll start my research into all your links... thanks!!
you think it will be easy to put the contents of the csv into 1 large array.... or a datatable? or even gridview... purpose being I have to dissect all the data and perform statistical/financial calculations?
Apr 07, 2012 06:20 PM|bbcompent1|LINK
I would load it into a datatable and process from there.
Apr 09, 2012 02:33 PM|solarissf|LINK
thanks so much for all your help