RE: excell to postgres
Chris Carbaugh <chris@leerelectric.com>
From: "Chris Carbaugh" <chris@leerelectric.com>
To: "'Hal Snyder'" <hal@vailsys.com>, <pgsql-general@hub.org>
Date: 2000-04-17T21:20:26Z
Lists: pgsql-general
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. Chris > -----Original Message----- > From: pgsql-general-owner@hub.org > [mailto:pgsql-general-owner@hub.org]On > Behalf Of Hal Snyder > Sent: Monday, April 17, 2000 4:41 PM > To: pgsql-general@hub.org > Subject: Re: [GENERAL] excell to postgres > > > Jeffrey <seesej@uswest.net> writes: > > > I don't understand the need for such complicated solutions. Why not > > just create a table with your shcema, pg_dump the table and insert > > your delimited .xls file in the pg_dump file. Then re-install the > > pg_dump-ed table. > > The above step would save the MS user from converting his .XLS files > to Access - all he does is Save As .CSV. Good idea. >