| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
| Cc: | Nageshwar Rao <NageshwarR(at)PLANETASIA(dot)COM>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: insert data from an microsoft excel |
| Date: | 2005-02-16 15:32:49 |
| Message-ID: | 20050216153248.GA23830@fetter.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-02-16 15:54:28 | Re: hung postmaster? |
| Previous Message | Tom Lane | 2005-02-16 15:17:16 | Re: Trading off large objects (arrays, large strings, large tables) for timeseries |