excel to mysql
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á
Last edited by jogol; 02-06-2006 at 11:04 AM.
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.
The Benevolent Administrator
No child should have to deal with a Brain Stem Tumor...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)