RE: excell to postgres

Поиск
Список
Период
Сортировка
От Chris Carbaugh
Тема RE: excell to postgres
Дата
Msg-id 002c01bfa8b2$c0846390$1901a8c0@leerelectric.com
обсуждение исходный текст
Ответ на Re: excell to postgres  (Hal Snyder <hal@vailsys.com>)
Список 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 по дате отправления:

Предыдущее
От: "Culberson, Philip"
Дата:
Сообщение: RE: Performance in subquery
Следующее
От: Hal Snyder
Дата:
Сообщение: Re: excel to postgres