To upload data from Excel into a MySQL database the easiest option to export the data as a CSV file. Make sure the columns of data match the fileds in the database, minus the id field, if you have one, as this will be automated.
Your csv line have to be something like this “Rei”,”New Tokyo 6″,”11234″, or like mine it may be “Rei”,”New Tokyo 6″,11234. Only the text fields enclosed with quotes.
I used PHP MyAdmin, so choose the import tab. Select the CSV file to import. Choose CSV and update the options like so:
fields terminated by ‘,’
enclosed by ‘”‘
lines terminated by ‘\n’

That should work. If you’re using the command line to manage MySQL try:
load data local infile ‘uniq.csv’ into table tblUniq
fields terminated by ‘,’
enclosed by ‘”‘
lines terminated by ‘\n’
(uniqName, uniqCity, uniqComments)

Explanation here:
http://www.tech-recipes.com/rx/2345/import_csv_file_directly_into_mysql/