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

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.

Thanks a lot.

Véro.
______________________________________________________
Boîte aux lettres - Caramail - http://www.caramail.com

> 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@wellsgaming.com]