Re: Import excel to postgres based website?

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Import excel to postgres based website?
Дата
Msg-id 56147BCA-37CF-43C7-B8D9-EED4B40FD214@decibel.org
обсуждение исходный текст
Ответ на Import to excel to postgres based website?  (novnov <novnovice@gmail.com>)
Список pgsql-general
On Jul 22, 2007, at 11:27 PM, novnov wrote:
> The answer may or many not be very postgres specific but...what are
> some
> possible routes that I could take to allows users to upload data
> from excel
> into a postgres via a website? I've never tried anything like this
> before.
> Are there standard modules that might help with this or will I have to
> create from scratch? I am obviously hoping to find something I can
> just plug
> in. Users would be expected to have the xls ordered properly for
> the routine
> to work.

How about converting the Excel file to CSV and loading that in with
COPY?
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



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

Предыдущее
От: Robert Landrum
Дата:
Сообщение: Re: GiST Support in 8.1
Следующее
От: "Zlatko Matic"
Дата:
Сообщение: Re: Import to excel to postgres based website?