Обсуждение: How to Import Excel Into PostgreSQL database

In response to Venkat Rao Tammineni :
> Dear All,
> 
>  
> 
>   I using PosgreSql8.1.I want to import Excel into PostgreSQL database. Is
> there any way to import ? .

Create a CSV-File and import that with COPY.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

Hi ,
Thanks a lot.

Regards
Venkat.

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of A. Kretschmer
Sent: Wednesday, December 24, 2008 2:54 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] How to Import Excel Into PostgreSQL database

In response to Venkat Rao Tammineni :
> Dear All,
> 
>  
> 
>   I using PosgreSql8.1.I want to import Excel into PostgreSQL database. Is
> there any way to import ? .

Create a CSV-File and import that with COPY.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

    Try this: http://sqlmanager.net/products/postgresql/manager/
   
    It's an application that includes a lot of tools for importing and exporting databases. It's the best tool i've used for these kind of actions, and to manage postgreSQL databases

Venkat Rao Tammineni escribió:

Dear All,

 

  I using PosgreSql8.1.I want to import Excel into PostgreSQL database. Is there any way to import ? .

 

Please anyone can guide me.

 

I am waiting for your great response.

 

Thanks

Venkat.