Re: [GENERAL] excel to postgres

2000-04-17 Thread Tom Cook
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 post

Re: [GENERAL] excel to postgres

2000-04-17 Thread Andrew Perrin - Demography
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 f

Re: [GENERAL] excel to postgres

2000-04-17 Thread Tom Cook
On 17 Apr 2000, Hal Snyder wrote: > "Chris Carbaugh" <[EMAIL PROTECTED]> 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 wr

Re: [GENERAL] excel to postgres

2000-04-17 Thread Hal Snyder
"Chris Carbaugh" <[EMAIL PROTECTED]> 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