From: Andrew Sullivan <ajs@crankycanuck.ca>
To: psql <pgsql-sql@postgresql.org>
Subject: Re: Import from Ms Excel
Date: Tue, 16 Mar 2004 06:29:30 -0500
Message-ID: <20040316112930.GA4436@phlogiston.dyndns.org> (raw)
In-Reply-To: <01db01c40b3b$2c897b40$7502a8c0@hdsc.com>
References: <01db01c40b3b$2c897b40$7502a8c0@hdsc.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: Import from Ms Excel
In-Reply-To: <20040316112930.GA4436@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox