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
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 |