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.
>
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 |