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.
You don't say what scripting language you're using, or what platform
you're running on.
If you have a Windows-based server, you could just install Excel and use
ODBC and some macros to open the uploaded file and process it.
If you're on a non-Windows platform then you'll want a module that can
read Excel files. There are various Perl modules on search.cpan.org that
might work for you.
Failing that, you can get people to save as a tab-separated-values file
(possibly via a macro so they just have one button to push). That is
easy to import via COPY.
--
Richard Huxton
Archonet Ltd