Re: Import excel to postgres based website?

From: "Gavin M(dot) Roy" <gmr(at)myyearbook(dot)com>
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 14:37:24
Message-ID: af1bce590707240737iec44b38j9e089cbbdebda7c9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Your easiest route will be to have them export a csv file out of excel and
write a script to import the csv into the database.

On 7/23/07, novnov <novnovice(at)gmail(dot)com> 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.
> --
> View this message in context: http://www.nabble.com/Import
> -excel-to-postgres-based-website--tf4127759.html#a11738475
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-07-24 14:42:18 Re: Strange behaviour with Xfs filesystem and unix_socket_directory
Previous Message Dawid Kuroczko 2007-07-24 14:25:45 Re: varchar does not work too well with IS NOT NULL partial indexes.