I am sure there are several ways of doing this. What I do, is just save the excel file as a tab-separated txt file... Then in mysql you call the "LOAD DATA local infile "/tmp/test.txt" into tabel tablename (columnname1, columnname2)" ;
I have made a little upload script for this.. If you want it I can mail it to ya.. msg me off list. -- trond -- > -----Opprinnelig melding----- > Fra: Daniel Berwig [mailto:[EMAIL PROTECTED]] > Sendt: 20. november 2001 19:25 > Til: [EMAIL PROTECTED] > Emne: [PHP-DB] Excel to Mysql > > > Is it possible to migrate data into a table in MS Excel to MySQL? > > Thanks in advance. > > Daniel Berwig > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
