Re: excel to postgres

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.

---------------------------------------------------------------------
Andrew J. Perrin - aperrin@demog.berkeley.edu - NT/Unix Admin/Support
Department of Demography    -    University of California at Berkeley
2232 Piedmont Avenue #2120  -    Berkeley, California, 94720-2120 USA
http://demog.berkeley.edu/~aperrin --------------------------SEIU1199

On Tue, 18 Apr 2000, Tom Cook wrote:

> On 17 Apr 2000, Hal Snyder wrote:
>
> > "Chris Carbaugh" <chris@leerelectric.com> writes:
> >
> > > If you really want to save the user some work/confusion, investigate
> > > what you can do with VB under XL.
> > >
> > > I would think XL allows you to set some options when export as CSV,
> > > with VB, you could write your own Save function.
> >
> > How messy to Save to a table via ODBC? Excel talking straight to
> > PostgreSQL - nice idea.
> >
>
> 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
> --------------------------------------------------
>