Обсуждение: export data from excel to postges

On Wed, Sep 24, 2003 at 15:13:40 +0900,
  Lee Weaver <lee@teczasky.ne.jp> wrote:
> Could someone please tell me where I could find info on exporting excel data
> into postgresql, or how to do it.  Thanks!

If you export your excel data into tab separated data files (one for
each table), then it will be relatively easy to import it into
postgres using the copy command.

Could someone please tell me where I could find info on exporting excel data into postgresql, or how to do it.  Thanks!

 

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@3times25.net

Building secure systems inspite of Microsoft