I've had a look at a number of programs but haven't found a solution-
I have a database in mySQL which I want to fill with data from an Excel spreadsheet.
The database has a number of fields which have set datatypes and some that are default NULL. Anything I've managed to convert is leaving the NULL fields blank, but not NULL.
The cPanel I'm using only allows CSV or SQL. Any ideas where to go from here?
----ANSWER:----
All good answers so far, but whilst researching some more I found this YouTube video: http://www.youtube.com/watch?v=JDBYU9f1p-I
I hadn't heard of it before but I downloaded Talend Open Studio and while the number of functions available seem a bit over the top for what I need it's been the most straight forward and accurate way to move Excel files to MySql I've come across.
All good answers so far, but whilst researching some more I found this YouTube video: http://www.youtube.com/watch?v=JDBYU9f1p-I
I hadn't heard of it before but I downloaded Talend Open Studio and while the number of functions available seem a bit over the top for what I need it's been the most straight forward and accurate way to move Excel files to MySql I've come across.