Re: URGENT - How to export data from EXCEL to PostgreSQL ou pgaccess as you want...

From: Jeremy Buchmann <jeremy(at)wellsgaming(dot)com>
To: veronique DROUELLE <v(dot)drouelle(at)caramail(dot)com>, <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: URGENT - How to export data from EXCEL to PostgreSQL ou pgaccess as you want...
Date: 2001-07-19 15:12:47
Message-ID: B77C46FF.32C7%jeremy@wellsgaming.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

> Hello,
>
> I'd like know how recover data from EXCEL table. This table
> contains values of a ELISA plate with coordonates (A1,
> A2...A12....H12).I'm explaining: columns are 1..12 and rows
> are A .. H and I'd like recover values of this table with
> coordonates. For example 4.256 for A4! and this, for the 96
> values...
>
> I know CSV format exists but I don't know how recover CSV
> enregistered data.

Save the Excel table as tab-delimited text and then you can use the COPY
command to dump it into PostgtreSQL.

-- Jeremy [jeremy(at)wellsgaming(dot)com]

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message veronique DROUELLE 2001-07-19 17:15:35 URGENT - How to export data from EXCEL to PostgreSQL ou pgaccess as you want...
Previous Message Reinhard Max 2001-07-19 14:05:35 Re: libpgtcl doesn't use UTF encoding of TCL