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