Re: How to Import Excel Into PostgreSQL database

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to Import Excel Into PostgreSQL database
Date: 2008-12-24 08:05:40
Message-ID: 20081224090540.0a521b3f@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 24 Dec 2008 01:43:36 -0600
Julio Cesar Sánchez González <knowhow(at)sistemasyconectividad(dot)com(dot)mx>
wrote:

> Venkat Rao Tammineni escribió:

> Try with csv format and think it's going a nothing problem. See
> http://darkavngr.blogspot.com/2007/06/importar-datos-externos-nuestra-base-de.html
> for example.

If this doesn't come to a satisfactory end [1] you may try with
odbc/dblink.

[1]
a) you may need to do it programmatically without manually opening
the excel sheet and pressing buttons
b) you may discover they dropped proper csv export between releases
as it happened to me moving from MS SQL 2000 to 2005

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-12-24 11:29:02 return query and function result type must be real because of OUT parameters
Previous Message Venkat Rao Tammineni 2008-12-24 07:55:24 Re: How to Import Excel Into PostgreSQL database