RE: excell to postgres

From: "Chris Carbaugh" <chris(at)leerelectric(dot)com>
To: "'Hal Snyder'" <hal(at)vailsys(dot)com>, <pgsql-general(at)hub(dot)org>
Subject: RE: excell to postgres
Date: 2000-04-17 21:20:26
Message-ID: 002c01bfa8b2$c0846390$1901a8c0@leerelectric.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)hub(dot)org
> [mailto:pgsql-general-owner(at)hub(dot)org]On
> Behalf Of Hal Snyder
> Sent: Monday, April 17, 2000 4:41 PM
> To: pgsql-general(at)hub(dot)org
> Subject: Re: [GENERAL] excell to postgres
>
>
> Jeffrey <seesej(at)uswest(dot)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.
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hal Snyder 2000-04-17 21:48:08 Re: excel to postgres
Previous Message Culberson, Philip 2000-04-17 21:01:55 RE: Performance in subquery