Re: Excel to mysql

you do
xls2csv spreadsheet.xls > spreadsheet.csv

then as a separate operation I do:
./csv2mysql.php spreadsheet.csv

but you could include the first operation as part of csv2mysql.php and
run it all in one command.

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

> Date: Mon, 1 Dec 2008 21:29:52 -0800 (PST)
> From: deepesh <deepeshgairola@gmail.com>
> Subject: Re: Excel to mysql
> To: CakePHP <cake-php@googlegroups.com>
>
>
> Hi jon ,
>
> thank you very much for your timely reply.
> Is your xls2csv a standalone application i mean do you have to start
> xls2csv then convert your excel in to csv format and then run your PHP
> script for import or its all like a php app !!
>
>
> Best regards,
> Deepesh
>
>
> On Dec 2, 10:25 am, Jon Molesa <rjmol...@gmail.com> wrote:
> > 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 <deepeshgair...@gmail.com> wrote:
> >
> >
> >
> > > Date: Mon, 1 Dec 2008 21:15:42 -0800 (PST)
> > > From: deepesh <deepeshgair...@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
> > rjmol...@consoltec.net
> > if you're bored or curioushttp://rjmolesa.com
>
--
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
-~----------~----~----~----~------~----~------~--~---