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
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?
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.
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.
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
doing this
solarissf
0 Points
60 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - using web develo...
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?
bbcompent1
All-Star
33873 Points
8776 Posts
Moderator
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - using web develo...
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
solarissf
0 Points
60 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - using web develo...
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?
bbcompent1
All-Star
33873 Points
8776 Posts
Moderator
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - using web develo...
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.
solarissf
0 Points
60 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - using web develo...
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.
bbcompent1
All-Star
33873 Points
8776 Posts
Moderator
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - using web develo...
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.
solarissf
0 Points
60 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - using web develo...
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 doing this
bbcompent1
All-Star
33873 Points
8776 Posts
Moderator
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - using web develo...
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?
bbcompent1
All-Star
33873 Points
8776 Posts
Moderator
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - using web develo...
Apr 06, 2012 04:03 PM|LINK
For examples on how that is done in code, check out these samples:
http://www.codeproject.com/KB/database/FinalCSVReader.aspx
http://www.codeproject.com/KB/database/CsvReader.aspx
http://www.codeproject.com/KB/database/Cs_CSV_import_export.aspx
http://helpindotnet.wordpress.com/2008/07/10/import-csv-to-sql-from-aspnet-c/
http://p2p.wrox.com/c/61543-import-csv-files-database-c.html
bbcompent1
All-Star
33873 Points
8776 Posts
Moderator
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - using web develo...
Apr 06, 2012 04:05 PM|LINK
And proof that they do support the use of CSV files: http://support.godaddy.com/help/1393