Upload Excel To Postgresql

• Postgres To Excel

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 HooperResponses.at 2001-02-02 05:25:45 from Francisco ReyesBrowse pgsql-novice by dateFromDateSubjectRobert B.

Postgres To Excel

Easter2001-02-01 18:49:48Ben Hooper2001-02-01 12:54:08.