Or if you don't use phpMyAdmin you can use LOAD DATA INFILE once you have saved the Excel doc as a .csv file:
http://www.mysql.com/doc/L/O/LOAD_DATA.html Jen Swofford [EMAIL PROTECTED] > -----Original Message----- > From: Peter Lovatt [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 29, 2002 4:49 PM > To: Chase; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Excel to MySQL?? > > > Hi > > from Excel export to csv > > use phpMyAdmin to load it into mysql (recent versions of phpMyAdmin has an > Excel import function) > > HTH > > Peter > > ----------------------------------------------- > Excellence in internet and open source software > ----------------------------------------------- > Sunmaia > www.sunmaia.net > [EMAIL PROTECTED] > tel. 0121-242-1473 > ----------------------------------------------- > > > -----Original Message----- > > From: Chase [mailto:[EMAIL PROTECTED]] > > Sent: 29 June 2002 22:22 > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Excel to MySQL?? > > > > > > Does anyone know of a way that I can export an Excel spreadsheet to a > > file that I can import to MySQL? I found a program that will do this > > for Access, but I would rather leave Access out of this if possible. > > Thanks!! > > > > Chase > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
