Re: Import from Ms Excel - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: Import from Ms Excel
Date
Msg-id 20040316112930.GA4436@phlogiston.dyndns.org
Whole thread Raw
In response to Import from Ms Excel  ("Kumar" <sgnerd@yahoo.com.sg>)
Responses Re: Import from Ms Excel  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Re: Import from Ms Excel  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-sql
On Tue, Mar 16, 2004 at 03:13:38PM +0530, Kumar wrote:
> Dear Friends,
> 
> Is possible to import data from MS Excel sheet into postgres
> database 7.3.4 running on Linux 7.2

Yes.  I find the easiest way is to export a delimited file from Excel
and use the \copy command in psql.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what 
you told them to.  That actually seems sort of quaint now.    --J.D. Baldwin


pgsql-sql by date:

Previous
From: "Kumar"
Date:
Subject: Import from Ms Excel
Next
From: Achilleus Mantzios
Date:
Subject: Re: Import from Ms Excel