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á
Bookmarks