> Does anyone know of a FREE utility that will export data from an MS > Excel file and import it to MySQL. I have found a bunch of nice > utilities, but none of them are FREE. I'm in a bind and have to get > over 2000 rows imported to my database by morning and don't have to > order one of the other solutions. >
Maybe you can use this: Save the Excel document as tab delimited text and use the mysql command LOAD DATA or the mysqlimport utility. mysql> LOAD DATA INFILE 'data.txt' INTO TABLE table; <http://www.mysql.com/doc/en/LOAD_DATA.html> You'd better check out the stuff about "enclosed by". -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
