excel to mysql

[barantamer]

hello , is there a free software that converts and excel file to sql query ?

if not is there anyone can tell me , how can i import an excel table to mysql database?

thanks

[NogDog]

If you use phpMyAdmin, you can save the Excel file as a CSV file, then from the table view in phpMyAdmin select the "Import" tab and choose the CSV option.

[barantamer]

i cannot find the csv option in the import tab ...
can you tell me exactly where it is ?

[TyeM]

The import tab will only be seen if you select the database you want to import into. This is the case in my version of MyPHPAdmin.