Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group