| 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: | Whole Thread | Raw Message | 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 |