Re: How to insert .xls files into database

From: "John D(dot) Burger" <john(at)mitre(dot)org>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to insert .xls files into database
Date: 2006-07-08 01:01:43
Message-ID: f3f4782d092030be5ac1e1cf00ddb2d8@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

One option is to write a Python translator to create CSV files, or even
an uploader to go directly from the Excel files to the database. There
is at least one module to read Excel files, in all their complexity:

http://cheeseshop.python.org/pypi/xlrd/0.5.2

and a number of Postgres modules:

http://wiki.python.org/moin/PostgreSQL

- John Burger
MITRE

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2006-07-08 02:08:55 Re: How to insert .xls files into database
Previous Message Michael Loftis 2006-07-07 23:44:26 Re: Bug? Changing where distinct occurs produces error?