Excel Data to MySQL

Hello folks, I have some information/data store in Microsoft EXcel spreadsheet that I wish to store in my Mysql DB for website use, can you guide to adding this excel data to MySQL db?

Thanks in advance folks.

 

Here is what I believe you have to do. I am assuming you have phpmyadmin installed on your server?

If you do, export the table in microsoft access to a "text" file and delimite it by ";".

Create the table in mysql matching the columns and types coming from your ms access database. Use the import function (make sure you have choosen the new table from phpmyadmin before clicking on the import tab). Navigate to your file and then choose the "CSV" option and match the delimiter.

Sorry for the vague of the directions. I can be more specific if I knew where your mysql database was at as well as what you use to manage it.

 

thanks cpucandy,,, I 'll give that a try later today.

 

I generally import the spreadsheet to Access and use a cool (and free) utility called MSAccess to MySQL. Probably not the most elegant solution, but works without a hitch every month.

 

Since GoDaddy only allows SQL files to be imported, I convert my table to CSV (I use OpenOffice.org) and then use the Excel to MySQL demo to convert to SQL.