Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 09, 2012 01:33 PM by solarissf
Apr 06, 2012 01:23 PM|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 01:27 PM|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 01:29 PM|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 01:38 PM|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 01:45 PM|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 02:06 PM|LINK
Sure, what you need to ask them is if they support Microsoft OLEDB 12 using Microsoft Excel files for importing.
Apr 06, 2012 03:56 PM|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 03:58 PM|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 04:03 PM|LINK
For examples on how that is done in code, check out these samples:
Apr 06, 2012 04:05 PM|LINK
And proof that they do support the use of CSV files: