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
> --------------------------------------------------
>