Received: from mail.greatbasin.net (mail.greatbasin.net [207.228.35.39])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f6JFECa55646
	for <pgsql-interfaces@postgresql.org>;
	Thu, 19 Jul 2001 11:14:12 -0400 (EDT)
	(envelope-from jeremy@wellsgaming.com)
Received: from [172.16.1.6] (rno-dsl0b-131.gbis.net [216.82.145.131])
	by mail.greatbasin.net (8.9.3-MySQL-0.2.3b/8.9.3) with ESMTP id
	IAA16595; Thu, 19 Jul 2001 08:12:27 -0700 (PDT)
User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.02.2022
Date: Thu, 19 Jul 2001 08:12:47 -0700
Subject: Re: URGENT - How to export data from EXCEL to
	PostgreSQL ou pgaccess as you want...
From: Jeremy Buchmann <jeremy@wellsgaming.com>
To: veronique DROUELLE <v.drouelle@caramail.com>,
	<pgsql-interfaces@postgresql.org>
Message-ID: <B77C46FF.32C7%jeremy@wellsgaming.com>
In-Reply-To: <995552135012591@caramail.com>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
X-Archive-Number: 200107/82
X-Sequence-Number: 1836



> 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]