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: (view raw or whole 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


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

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