If this is a one shot deal, you might want to try saving as a csv and
LOAD DATA INFILE in mysql
~Rolan
David Mintz wrote:
Hey everyone,
Is anyone familiar with this Spreadsheet_Excel_Reader class?
http://sourceforge.net/project/showfiles.php?group_id=99160
I need to import Excel to MySQL. This class seems promising -- I have
started playing and can get the data into PHP, no problem. Except that
the single quotes, double quotes, em dashes, et cetera are wreaking
havoc. Does anyone know of any solution? I see there are
setOutputEncoding() and setUTFEncoder() methods but I am not sure
whether they are what I need and what values to pass them.
Thanks.
--
David Mintz
http://davidmintz.org/
En Nueva York el tránsito de la belleza a la desolación sucede siempre
expeditivamente, como si el principio universal de máxima eficiencia
hubiera aconsejado la supresión de gradaciones intermedias.
-- Antonio Muñoz Molina, Ventanas de Manhattan
------------------------------------------------------------------------
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
