[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice
Subject:    RE: loading mysql data
From:       "Eleknader" <eleknader () phnet ! fi>
Date:       2001-07-01 7:39:59
[Download RAW message or body]

Or if you run Apache and php, install php my admin. You can
export the data into a textfile with www browser and import
it then to KSpread.

php my admin is very useful for managing a mysql database.

Eleknader

> -----Original Message-----
> From: koffice-admin@master.kde.org
> [mailto:koffice-admin@master.kde.org]On Behalf Of Corey Schuhen
> Sent: 1. heinäkuuta 2001 13:02
> To: koffice@max.tat.physik.uni-tuebingen.de
> Subject: Re: loading mysql data
>
>
>
> I think there is  You can use mysqldum that comes with the mysql
> clients like:
>
> mysqldump --tab=. -u MySQL_User -pMySQL_Password Database
>
> This will create a .sql and .txt file for each table in the database. By
> default this will be Tab seperated which I think Kspread can
> import but this
> can be changed to coma seperated etc. look at mysqldump --help It
> is quite
> powerful.
>
> Corey
>
>
> On Fri, 29 Jun 2001 19:34, Michael Baxter wrote:
> > Dear koffice,
> >                   Thanks for the k system - its great.
> >
> >                   My only problem with it is that I need to load data
> > output from a mysql select -> file into a spreadsheet. Kspread would be
> > terrific. Is there a way to do this?
> >
> >                         Thanks,
> >                               mickb.
>

[prev in list] [next in list] [prev in thread] [next in thread]