Subject Re: Exporting to Excel from PHP firebird and Importing from excel to a database
Author pirulo64
Well the reason I want to do this way is because any given user needs
to download a report once the click a time period would just not show in the webpage screen but rather download and keep it for a records
that is the main issue here.

thanks



--- In firebird-php@yahoogroups.com, Lester Caine <lester@...> wrote:
>
> pirulo64 wrote:
> > I'm a new to firebird I need a way to export my web report php to excel
> > and import to from excel to a database users new this ability to do it
> > but most important is export.
>
> Well I use .csv between spreadsheets and what is happening in the database. My
> 'report generator' displays the results on the screen, and also offers a .csv
> dump which users can simply open in OO or Excel and then use the data from.
>
> Import is a little more difficult, but ibwebadmin will copy a .csv file into a
> database table, and I have several packages in bitweaver which process .csv
> from various sources and build a suitable copy of the data in the database.
>
> There is not a single way of doing it in PHP, but for test purposes,
> FlameRobin allows you to export csv, which is one of the sources I then use so
> import into other applications.
>
> It does depend on what you are trying to transfer. In many cases it's simply
> easier to provide functions in you PHP application to do some of the work,
> rather than doing it in excel.
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk//
> Firebird - http://www.firebirdsql.org/index.php
>