excel to mysql

[amit007]

hiiiiiiiiiiiiii iiiii,
i need to write a code to convert excel data into mysql.
plz help me.
thanks in advance

[devsusen]

Hi,
search PEAR for Excel file reader package.

hiiiiiiiiiiiiii iiiii,
i need to write a code to convert excel data into mysql.
plz help me.
thanks in advance

susen

[amit007]

thanx for reply
i have solved it with
"LOAD DATA LOCAL INFILE 'c:/1.txt' INTO TABLE aa FIELDS TERMINATED BY '%%' lines terminated by '/n' ";