> Hello All,
> How would I go about importing a large M$ Excel sheet into a
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. Easter||Date: 2001-02-01 18:49:48|
|Subject: Re: how to deteck empty tables in outer joins|
|Previous:||From: Ben Hooper||Date: 2001-02-01 12:54:08|