NYCPHP Meetup

[woodwort]

I think the easiest way is to save the excel sheet as csv.
Then you can create a quick script that explodes the data.
Run the data through htmlentities and output a SQL statement for each line.
I could probably organize a sample script if you need it.

Good Luck.
Garrett


John Nunez wrote:

> Hi Guys,
>
> How can I export a file from Excel which has 1000's of names that uses 
> German, French, Spanish accented characters to MySQL 3.23.58?  I know 
> that MySQL 4 has unicode but upgrading this database is not possible 
> right now.
>
> Thanks,
> John Nunez
>
> _______________________________________________
> New York PHP Talk Mailing List
> AMP Technology
> Supporting Apache, MySQL and PHP
> http://lists.nyphp.org/mailman/listinfo/talk
> http://www.nyphp.org
>
>