NYCPHP Meetup

[Rolan Yang]

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