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 7F001D1E943 for ; Tue, 16 Mar 2004 11:29:30 +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 20695-03 for ; Tue, 16 Mar 2004 07:29:31 -0400 (AST) Received: from fep01-mail.bloor.is.net.cable.rogers.com (fep01-mail.bloor.is.net.cable.rogers.com [66.185.86.71]) by svr1.postgresql.org (Postfix) with ESMTP id 27297D1E93F for ; Tue, 16 Mar 2004 07:29:28 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep01-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040316112905.XAXP230350.fep01-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Tue, 16 Mar 2004 06:29:05 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id A378F3DC8; Tue, 16 Mar 2004 06:29:30 -0500 (EST) Date: Tue, 16 Mar 2004 06:29:30 -0500 From: Andrew Sullivan To: psql Subject: Re: Import from Ms Excel Message-ID: <20040316112930.GA4436@phlogiston.dyndns.org> Mail-Followup-To: psql References: <01db01c40b3b$2c897b40$7502a8c0@hdsc.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <01db01c40b3b$2c897b40$7502a8c0@hdsc.com> User-Agent: Mutt/1.5.5.1+cvs20040105i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep01-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Tue, 16 Mar 2004 06:29:05 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/161 X-Sequence-Number: 17260 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. A -- Andrew Sullivan | ajs@crankycanuck.ca I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin