Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group