Re: Excel to MySQL

Thanks Michael and Richard I took your advice and wrote a PHP script to import it. I was having a hard time getting Excel on my Mac to export to CSV and Tab Delim, but finally got it to give me a plain text file which worked fine with fopen(). Joe On Friday, January 3, 2003, at 02:32 PM, Michael J. Pawlowsky wrote:

I think BiffWriter might do it... By why not simply output a comma delimited files from excel and import it in with a small php script. Mike *********** REPLY SEPARATOR *********** On 03/01/2003 at 2:20 PM Joe LoMoglio wrote:

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. Joe LoMoglio -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php