Re: Excel to mysql

I usually use xls2csv and then a custom php script to import that into
the database. You can even wrap it into one operation by calling
xls2csv from inside your php script. It isn't cake specific, but if
you'd like my script contact me off list. FYI, I use linux and xls2csv
is an available tool. Not sure if there is a Windows version. I think
I ran it on Mac once using fink or port. It's part of catdoc I believe.

*On Mon, Dec 01, 2008 at 09:15:42PM -0800 deepesh <deepeshgairola@gmail.com> wrote:

> Date: Mon, 1 Dec 2008 21:15:42 -0800 (PST)
> From: deepesh <deepeshgairola@gmail.com>
> Subject: Excel to mysql
> To: CakePHP <cake-php@googlegroups.com>
>
>
> Hi All,
> I have came across a script in my application where Excel
> data needs to be imported in to Mysql . All i have come across is that
> it needs to be a CSV or .txt file to import all the data from file to
> Mysql . Is there any way out for EXCEL import script in Cake !!
>
>
> Best regards,
> Deepesh
>
--
Jon Molesa
rjmolesa@consoltec.net
if you're bored or curious
http://rjmolesa.com

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---