Re: How to Import Excel Into PostgreSQL database - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject Re: How to Import Excel Into PostgreSQL database
Date
Msg-id 20081224090540.0a521b3f@dawn.webthatworks.it
Whole thread Raw
In response to Re: How to Import Excel Into PostgreSQL database  (Julio Cesar Sánchez González<knowhow@sistemasyconectividad.com.mx>)
List pgsql-general
On Wed, 24 Dec 2008 01:43:36 -0600
Julio Cesar Sánchez González <knowhow@sistemasyconectividad.com.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


pgsql-general by date:

Previous
From: "Venkat Rao Tammineni"
Date:
Subject: Re: How to Import Excel Into PostgreSQL database
Next
From: Ivan Sergio Borgonovo
Date:
Subject: return query and function result type must be real because of OUT parameters