Pasting of Excel data into tables

From: Aren Cambre <aren(at)arencambre(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Pasting of Excel data into tables
Date: 2012-02-22 20:37:02
Message-ID: CAA1mBro2jP-0-io_9YcPjHOsezXjnQcj-ZGEsBN5ZJf-4k1zPQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Is it possible to paste Excel data into tables, presuming the data and
structure is similar to the Postgres table?

It looks like I ought to be able to paste copied data into the Edit Data
dialog, but that paste only ends up in one cell. E.g., if I have a table
with 5 columns, and I copy a 5 col x 1000 row Excel spreadsheet and then
paste it into the row in Edit Data marked ***, all the data goes into the
first cell.

I'm asking because if this doesn't work, looks like I need to do an import
from CSV. That's not the end of the world, but it's much less convenient
than copy-paste, which works in some other apps.

Aren

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-02-22 20:48:30 Re: Pasting of Excel data into tables
Previous Message Guillaume Lelarge 2012-02-21 22:36:30 Re: Trigger Script Error