Re: [GENERAL] excel to postgres
"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 a table via ODBC? Excel talking straight to PostgreSQL - nice idea.
Re: [GENERAL] excel to postgres
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 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, 5034Sydney, NSW, 2000 Phone: +61 8 8272 1555 Phone: +61 2 9283 0877 Fax: +61 8 8271 1199 Fax: +61 2 9283 0866 --
Re: [GENERAL] 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 - [EMAIL PROTECTED] - 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" [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 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, 5034Sydney, NSW, 2000 Phone: +61 8 8272 1555 Phone: +61 2 9283 0877 Fax: +61 8 8271 1199 Fax: +61 2 9283 0866 --
Re: [GENERAL] excel to postgres
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, 5034Sydney, NSW, 2000 Phone: +61 8 8272 1555 Phone: +61 2 9283 0877 Fax: +61 8 8271 1199 Fax: +61 2 9283 0866 --
