RE: excell to postgres - Mailing list pgsql-general

From Chris Carbaugh
Subject RE: excell to postgres
Date
Msg-id 002c01bfa8b2$c0846390$1901a8c0@leerelectric.com
Whole thread Raw
In response to Re: excell to postgres  (Hal Snyder <hal@vailsys.com>)
List 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.
>


pgsql-general by date:

Previous
From: "Culberson, Philip"
Date:
Subject: RE: Performance in subquery
Next
From: Hal Snyder
Date:
Subject: Re: excel to postgres