Import Excel into MySQL?

[Anon]

Is it possible to import data from excel files into MySQL database?

[Anon]

I did it myself

If anyone need a help I can help.

[Anon]

Could you describe the general steps for doing this?

[Anon]

Save your excel file as CSV, notice thet CSV allows you to save only one sheet of data.

I use phpMyAdmin, you can get it on site http://sourceforge.net/projects/phpmyadmin

Crate Database and table, make sure that your table have the same count of fields that columns in *.csv file.

clicking on table name in left frame you should see link 'Insert textfiles into table' in right frame. Click it.

In field 'Location of the textfile' search for your *.csv file. Put a comma in 'Fields
enclosed by' and make sure that OPTIONALLY is checked.