From: Jeff Eckermann <jeff_eckermann@yahoo.com>
To: Andrew Sullivan <ajs@crankycanuck.ca>
To: psql <pgsql-sql@postgresql.org>
Subject: Re: Import from Ms Excel
Date: Tue, 16 Mar 2004 08:13:57 -0800 (PST)
Message-ID: <20040316161357.52404.qmail@web20812.mail.yahoo.com> (raw)
In-Reply-To: <20040316112930.GA4436@phlogiston.dyndns.org>
--- Andrew Sullivan <ajs@crankycanuck.ca> wrote:
> 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 couple of quick points:
* Don't use .csv, unless you are quite sure that your
data does not include any commas. "Copy" isn't smart
enough to know that the quotes mean "ignore the
delimiters inside here".
* If your data does include commas, even using
tab-delimited will cause Excel to pointlessly quote
those columns, and the quotes will be imported as data
unless you remove them.
* Make sure to remove any carriage returns that may
have been included with your line endings. I think
newer versions of "copy" are better about handling
that, but best to be sure...
>
> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
__________________________________
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com
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: jeff_eckermann@yahoo.com, ajs@crankycanuck.ca
Subject: Re: Import from Ms Excel
In-Reply-To: <20040316161357.52404.qmail@web20812.mail.yahoo.com>
* 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