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 7E9BAD1E8AB for ; Sun, 21 Mar 2004 16:54:49 +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 92488-01 for ; Sun, 21 Mar 2004 12:54:43 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 0B03FD1D2CE for ; Sun, 21 Mar 2004 12:54:43 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i2LGsg1Y087851 for ; Sun, 21 Mar 2004 16:54:42 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i2LGPkjg083650 for pgsql-sql@postgresql.org; Sun, 21 Mar 2004 16:25:46 GMT Date: Sun, 21 Mar 2004 17:25:31 +0100 From: Hans de Bruin User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 X-Accept-Language: en-us, en MIME-Version: 1.0 X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Import from Ms Excel References: <01db01c40b3b$2c897b40$7502a8c0@hdsc.com> In-Reply-To: <01db01c40b3b$2c897b40$7502a8c0@hdsc.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 16 Message-ID: <405dc1fb$0$574$e4fe514c@news.xs4all.nl> X-Complaints-To: abuse@xs4all.nl To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/250 X-Sequence-Number: 17349 Kumar wrote: > Dear Friends, > > Is possible to import data from MS Excel sheet into postgres database > 7.3.4 running on Linux 7.2 > Install the postgress ODBC drivers. Create a new access database. Create two linked tabels, one to a table in de database and one to the excel sheet. Use a insert into query to transfer the data. -- Hans de Bruin http://eratosthenes.xs4all.nl