Re: insert data from an microsoft excel - Mailing list pgsql-general

From David Fetter
Subject Re: insert data from an microsoft excel
Date
Msg-id 20050216153248.GA23830@fetter.org
Whole thread Raw
In response to Re: insert data from an microsoft excel  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
On Wed, Feb 16, 2005 at 08:05:55AM -0700, Ed L. wrote:
> On Wednesday February 16 2005 7:48, David Fetter wrote:
> > On Wed, Feb 16, 2005 at 04:46:09PM +0530, Nageshwar Rao wrote:
> > > Is there is way to load data from as Microsoft excel into
> > > database tables in postgresql7.4.x
> >
> > Once you've upgraded to 8.0x--a good idea anyhow--you can use
> > DBI-Link with the DBD::Excel driver.
>
> Wouldn't ODBC work for this??

It probably would.

> I've pulled into Excel from Pg as far back as pg 6.5, but never
> tried pushing from Excel into Pg...

DBI-Link makes it pretty trivial to pull any tabular data into
PostgreSQL :)

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Trading off large objects (arrays, large strings, large tables) for timeseries
Next
From: Tom Lane
Date:
Subject: Re: hung postmaster?