Re: Import an Excel table to a Postgresql one

Yet another alternative:

Create an ODBC, OLEDB or JDBC connection to PostgreSQL and Excel.
Create a target table in the PostgreSQL table with the attributes that
you desire.
Do an INSERT/SELECT to move the data.

All the data type translations will be done for you by the driver.

If you have thousands of spreadsheet tables, I would suggest using a
specialized tool for the job instead of a manual process to eliminate
errors.

You might want to rename the tables imported by the ODBC driver for MS
Excel, because it will have strange default names like:
country_codes_Excel.dbo.`Sheet1$` which are not exactly enlightening,
unless the spreadsheets already have reasonable names spelled out for
them.

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of
> Daniele Beauquier
> Sent: Friday, September 17, 2004 9:51 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Import an Excel table to a Postgresql one
>
>
> How to import an Excel table into a Postgresql table in a simple way?