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@xxxxxxxxxx http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
