Re: import content of XLS file into PostgreSQL

Hello,

On 8/8/07, Roberto Mello <roberto(dot)mello(at)gmail(dot)com> wrote:
> On 8/8/07, Ivan Zolotukhin <ivan(dot)zolotukhin(at)gmail(dot)com> wrote:
> > Hello,
> >
> > One more way to do it with mouse clicking only is OpenOffice. Get OO
> > and install PostgreSQL driver into OpenOffice Database application,
> > then you'll be able to import/export spreadsheets to and from database
> > tables and work with DB tables just like they are spreadsheets.
>
> That should be the easiest way if you're not programming-inclined. I
> don't know if others have suggested it, but you could export the XLS
> to csv (comma-separated values) and use a csv-parsing module in a
> programming language (Python has one) to grab only the values you want
> and import into PostgreSQL.

Sure. But if you use XLS one can suspect that you're not
programming-inclined :) But seriously, OO Database is a nice thing
because you'd better move all this documents that many people prepare
in spreadsheets right inside PostgreSQL. Your xls users won't even
notice the change while their data will be being stored in the DB
directly without any files.

Regards,
Ivan