Re: Import from Ms Excel

From: Hans de Bruin <hans(at)nl(dot)invalid>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Import from Ms Excel
Date: 2004-03-21 16:25:31
Message-ID: 405dc1fb$0$574$e4fe514c@news.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Erik Thiele 2004-03-22 09:20:31 special integrity constraints
Previous Message Erik Thiele 2004-03-19 15:27:58 Re: triggers on commit