Re: insert data from an microsoft excel

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!