RE: Importing Excel Spreadsheets into PostgreSQL

From: "Ben Hooper" <Ben(dot)Hooper(at)diskcopy(dot)com(dot)au>
To: "PostgreSQL Novice Mailing List" <pgsql-novice(at)postgresql(dot)org>
Subject: RE: Importing Excel Spreadsheets into PostgreSQL
Date: 2001-02-01 13:49:04
Message-ID: CFEIKFONBJABHENFFFFOAEBDCDAA.Ben.Hooper@diskcopy.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> Hello All,
>
> How would I go about importing a large M$ Excel sheet into a
> PostgreSQL
> database?
>

After a few dozen combinations I was able to answer my own question.

1. Save the Excel spreadsheet as comma delimited.

2. run 'psql mydatabase'

3. run 'COPY mytable FROM '/myfile.csv' USING DELIMITERS ',';

and it works!

In response to

  • at 2001-02-01 12:54:08 from Ben Hooper

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Robert B. Easter 2001-02-01 18:49:48 Re: how to deteck empty tables in outer joins
Previous Message Ben Hooper 2001-02-01 12:54:08