RE: Importing Excel Spreadsheets into PostgreSQL - Mailing list pgsql-novice

From Ben Hooper
Subject RE: Importing Excel Spreadsheets into PostgreSQL
Date
Msg-id CFEIKFONBJABHENFFFFOAEBDCDAA.Ben.Hooper@diskcopy.com.au
Whole thread Raw
In response to  ("Ben Hooper" <Ben.Hooper@diskcopy.com.au>)
Responses RE: Importing Excel Spreadsheets into PostgreSQL
List 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!



pgsql-novice by date:

Previous
From: "Ben Hooper"
Date:
Subject:
Next
From: "Robert B. Easter"
Date:
Subject: Re: how to deteck empty tables in outer joins