re: How to insert .xls files into database

Поиск
Список
Период
Сортировка
От lanczos@t-zones.sk
Тема re: How to insert .xls files into database
Дата
Msg-id 20060707224140.13395.qmail@ewm.e-zones.sk
обсуждение исходный текст
Ответы Re: How to insert .xls files into database  ("John D. Burger" <john@mitre.org>)
Re: How to insert .xls files into database  (Adrian Klaver <aklaver@comcast.net>)
Re: =?UTF-8?Q?re: How to insert .xls files into  (Guy Fraser <guy@incentre.net>)
Список pgsql-general
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Adrian Klaver
>
> I guess the solution depends on what is a 'large amount of data'. The
> most time consuming part is going to be converting the single data
> elements at the top of each sheet into multiple elements. I would
> create columns for the data in the sheet. At the same time I would
> order the columns to match the database schema. Then it would a matter
> of cut and paste to fill the columns with the data. The event id's
> could be renumbered using Excel's series generator to create a non
> repeating set of id's. If the amount of data was very large it might
> pay to create some macros to do the work. Once the data was filled in
> you would have a couple of choices. One, as mentioned by Ron would be
> to use OpenOffice v2 to dump the data into the database. The other
> would be to save the data as CSV and use the psql \copy command to
> move the data into the table.
> On Friday 07 July 2006 09:40 am, Parang Saraf wrote:

Evrything You described is familiar to me, except the OpenOffice v2 dump - could You explain this more in details pls?
Itried to do it many times, without success. 

Thank You

Tomas

[del]

> --
> Adrian Klaver
> aklaver@comcast.net


В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Bug? Changing where distinct occurs produces error?
Следующее
От: Michael Loftis
Дата:
Сообщение: Re: Bug? Changing where distinct occurs produces error?