Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group