Free Methods to Convert Excel to mySQL?

Alistair · Aug 24, 2004, 08:29 PM

Does anybody know of any methods I could use to convert an Excel file into a mySQL database. I would appreciate any help/advice as I really don't want ot manually convert 800+ records over...

PS. I've been searching google for quite some time now to no avail

Lots of pay to use programs though.

UberLord · Sep 6, 2004, 10:10 PM

I know this is old but here's a link which should help you

http://www.phpbuilder.com/columns/kenlin20031229.php3

BTW, why not use a PostgreSQL database? It's much better .....

mrQQ · Sep 22, 2004, 05:00 PM

hows postgresql better than mysql?

and to answer the question: just save the excel file as csv, then write a simple say php script like

$f = file("data.csv");
for ($i=0;$i<count($f);$i++) {
$d = explode(';', $f[$i]);
..
}

you get the idea..

Aug 24, 2004, 08:29 PM	#1
Alistair Spoos Join Date: May 2002 Location: State College, PA, USA Posts: 435 Rep Power: 0 System Specs	Free Methods to Convert Excel to mySQL? Does anybody know of any methods I could use to convert an Excel file into a mySQL database. I would appreciate any help/advice as I really don't want ot manually convert 800+ records over... PS. I've been searching google for quite some time now to no avail Lots of pay to use programs though. __________________ - Alistair

Sep 6, 2004, 10:10 PM	#2
UberLord A Legend in Underwear Join Date: May 2002 Location: Unknown Posts: 5,255 Rep Power: 0	I know this is old but here's a link which should help you http://www.phpbuilder.com/columns/kenlin20031229.php3 BTW, why not use a PostgreSQL database? It's much better ..... __________________ Gentoo Linux - Developer (baselayout) Read my blog "I contend that we are both atheists. I just believe in one fewer god than you do. When you understand why you dismiss all the other possible gods, you will understand why I dismiss yours." Stephen Roberts

Sep 22, 2004, 05:00 PM	#3
mrQQ DriverHeaven Newbie Join Date: Sep 2004 Posts: 14 Rep Power: 0	hows postgresql better than mysql? and to answer the question: just save the excel file as csv, then write a simple say php script like $f = file("data.csv"); for ($i=0;$i<count($f);$i++) { $d = explode(';', $f[$i]); .. } you get the idea.. __________________ [color=silver]Don't judge a thing till you know what's inside[/color]