Re: insert data from an microsoft excel

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Nageshwar Rao <NageshwarR(at)PLANETASIA(dot)COM>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: insert data from an microsoft excel
Date: 2005-02-16 12:48:18
Message-ID: 08251DAC-8019-11D9-B376-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Feb 16, 2005, at 6:16 AM, Nageshwar Rao wrote:

> Is there is way to load data from as Microsoft excel into database
> tables in postgresql7.4.x

Sure. Export the data into a CSV file. Then import it using psql and
the \COPY command.

http://www.postgresql.org/docs/8.0/interactive/app-psql.html
http://www.postgresql.org/docs/8.0/interactive/sql-copy.html

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2005-02-16 13:14:56 Re: Lost rows/data corruption?
Previous Message Marco Colombo 2005-02-16 12:46:55 Re: Lost rows/data corruption?