Any ways to convert Excel to MySQL? [Archive]

View Full Version : Any ways to convert Excel to MySQL?

laychoo135

07-02-2003, 05:33 PM

Hi all

Wish to know are there ways to convert Excel spreadsheet to MySQL? I have a long long lists of data in Excel format. It would be tedious to key in them in MySQL.

I know there are softwares on the net that can do the conversion but they are chargeable. :rolleyes:

raf

07-02-2003, 07:25 PM

Excell can't convert them to MySQL, but you can save them in excell as a csv file, and them import them into MySQL (using phpMyAdmin or another db-frontend)

Or take a look at some other db-frontends that can import excell-data like http://www.mysqlstudio.com but if you google for a 'MySQL GUI frontend' you'll probably find some others.