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
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 |