excel to mysql

[jogol]

hi,

is there a free and simple way to import a xls file into a mysql db?

the only thing i found was http://www.convert-in.com/xls2sql.htm which is 29 bucks. that´s not much and ok, but who likes to pay when there might be a simple solution? :)

UPDATE: i found a way to do it without any additional software. export the xls as csv and prepare the table rows in phpmyadmin. then got to sql in phpmyadmin and use the "import text file" feature. et voilá :)

regards,
jogol

[Compguy Pete]

As a side note there are a couple of converters out there that are free... I'll look up the link again if anyone else should need it.