excel to mysql
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?
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.
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
i cannot find the csv option in the import tab ...
can you tell me exactly where it is ?
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)