X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C2706D1E929 for ; Tue, 16 Mar 2004 11:41:50 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 27890-01 for ; Tue, 16 Mar 2004 07:41:51 -0400 (AST) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id CF033D1E928 for ; Tue, 16 Mar 2004 07:41:46 -0400 (AST) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id i2GBgkNu001476; Tue, 16 Mar 2004 13:42:46 +0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id i2GBgkYt001472; Tue, 16 Mar 2004 13:42:46 +0200 Date: Tue, 16 Mar 2004 13:42:45 +0200 (EET) From: Achilleus Mantzios To: Andrew Sullivan Cc: psql Subject: Re: Import from Ms Excel In-Reply-To: <20040316112930.GA4436@phlogiston.dyndns.org> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/162 X-Sequence-Number: 17261 O kyrios Andrew Sullivan egrapse stis Mar 16, 2004 : > On Tue, Mar 16, 2004 at 03:13:38PM +0530, Kumar wrote: > > Dear Friends, > > > > Is possible to import data from MS Excel sheet into postgres > > database 7.3.4 running on Linux 7.2 > > Yes. I find the easiest way is to export a delimited file from Excel > and use the \copy command in psql. Another fancy lib (although not necessarilly pgsql specific), is the POI project from jakarta. You can read/write M$ XLS documents from java, and subsequently (via jdbc) manipulate pgsql tables. The good part is that you can dynamically generate an excel file with arbitary content. > > A > > -- -Achilleus