| From: | Jim Nasby <decibel(at)decibel(dot)org> |
|---|---|
| To: | novnov <novnovice(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Import excel to postgres based website? |
| Date: | 2007-07-24 21:07:19 |
| Message-ID: | 56147BCA-37CF-43C7-B8D9-EED4B40FD214@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James B. Byrne | 2007-07-24 21:13:02 | ssl connections to postgresql |
| Previous Message | Robert Landrum | 2007-07-24 20:56:32 | Re: GiST Support in 8.1 |