NewWebDesigner
asked on
making a sql database from an ms excel file
Hello, I have an excel file that I need to make into an sql file. How do I do that in PHP? Or if anyone wants to do it for me, the excel file is attached.
Accreditation-2012-06.xls
Accreditation-2012-06.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Cobol and other responders,
I tried do as you say, first Excel says that my file "may not contain features that are compatible with csv" secondly, when I save it anyway as a csv and try to import it into PHPMyAdmin, I get an error saying the file is too large. What should I do now?
I tried do as you say, first Excel says that my file "may not contain features that are compatible with csv" secondly, when I save it anyway as a csv and try to import it into PHPMyAdmin, I get an error saying the file is too large. What should I do now?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The file is less than 3mb, ughh this is annoying. There has to be a way to do this without going to great lengths.
ASKER
I broke it up and now i get the error: "#2006: MySQL server has gone away" what is that about? I am using WAMP 2.2
It should be easier, but it's not. MS creates as many barriers to open source as it can. I have to assume the conversions are problematic because A converter like this sells for a hundred bucks.
I don't know if it is worth that much, but the fact that they can sell such a thing probably indicates that you are not going to have an easy time of it.
Cd&
I don't know if it is worth that much, but the fact that they can sell such a thing probably indicates that you are not going to have an easy time of it.
Cd&
There are a bunch of ways to get that error. It appears a lot of it is caused by windows.
Here is the mysql manual page
Cd&
Here is the mysql manual page
Cd&
ASKER
The manual was of no help. Anybody else got a suggestion or can do it and just send me the sql file? Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Cd&