Re: excel to postgres - Mailing list pgsql-general

From Tom Cook
Subject Re: excel to postgres
Date
Msg-id Pine.LNX.4.10.10004181315110.17022-100000@frog.adl.ardec.com.au
Whole thread Raw
In response to Re: excel to postgres  (Andrew Perrin - Demography <aperrin@demog.berkeley.edu>)
List pgsql-general
On Mon, 17 Apr 2000, Andrew Perrin - Demography wrote:

> Sure, VB works, as would perl with DBD::ODBC module.  I've been using that
> technique for porting a database from access to postgres, and it should
> work equally well with excel-based ODBC connections.  Disadvantage to the
> original poster is that it does require a Windows machine to read the
> Excel file.

Probably if users are saving to an excel file to be put into access and
then shipped of to a postgres instance then there is a windows machine
around. So write a function to save to the database instance, and then
alias it to a menu item 'Save to Database' or something like that.

[snip]
> > This would have to be doable in VB, wouldn't it? Doesn't it have some sort
> > of ODBC functionality? I'm no expert here (never used the language) but
> > I'd have thought it'd have to be in there...

Cheers
--
Tom Cook - Software Engineer

"Christ died for sin, the righteous for the unrighteous, to bring you to God."
    - 1 Peter 3:18

LISAcorp - www.lisa.com.au

--------------------------------------------------
38 Greenhill Rd.          Level 3, 228 Pitt Street
Wayville, SA, 5034        Sydney, NSW, 2000

Phone:   +61 8 8272 1555  Phone:   +61 2 9283 0877
Fax:     +61 8 8271 1199  Fax:     +61 2 9283 0866
--------------------------------------------------


pgsql-general by date:

Previous
From: Andrew Perrin - Demography
Date:
Subject: Re: excel to postgres
Next
From: Bruce Momjian
Date:
Subject: PostgreSQL book completed though chapter 14