Re: export data from excel to postges

From: Geoffrey <esoteric(at)3times25(dot)net>
To: Ge'mes Ge'za <geza(at)kzsdabas(dot)sulinet(dot)hu>
Cc: Lee Weaver <lee(at)teczasky(dot)ne(dot)jp>, pgsql-admin(at)postgresql(dot)org
Subject: Re: export data from excel to postges
Date: 2003-09-24 10:26:13
Message-ID: 3F717145.9040804@3times25.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

THere are perl modules to export excel. I've never used them, can't
vouch for their accuracy. That said, perl could do your export and
input to the db via dbi/dbd.

Ge'mes Ge'za wrote:
> Lee Weaver i'rta:
>
>
>>Could someone please tell me where I could find info on exporting
>>excel data into postgresql, or how to do it. Thanks!
>
>
> Try to save your data from excel in csv format and then use a _COPY_ to
> load it to a _previously created table_._
>
> _Good Luck!
>
> Geza Gemes_
> _
>

--
Until later, Geoffrey esoteric(at)3times25(dot)net

Building secure systems inspite of Microsoft

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Treat 2003-09-24 13:58:53 Re: STATEMENT level TRIGGER functions
Previous Message Arjen van der Meijden 2003-09-24 09:52:36 Re: [GENERAL] Fatal error: Allowed memory size of 8388608