Re: excell to postgres

Hi!

You can use Excel own export function to save the file - for example in
CSV (comma delimited).
Then, as Harold says, use COPY inside pgsql to read.
I don't know how will be character escaping in excel/pgsql.

Better yet, would be to install ODBC driver for postgres on your windows
system, and then open the ODBC datasource in excel.
You will then be able to simply drag and drop data from the Excel
worksheet to the pg database that you will be connecting via odbc.

M$ Access is another solution. In that case, you must set up a data source
in Control Panel, ODBC, using the Excel file database driver - thus making
an odbc database directly from the excel file. You will then be able to
use M$ Access functionalities (or PgAdmin if you prefer) to do the export.

Regards, Silvio

On Mon, 17 Apr 2000, Haroldo Stenger wrote:
> "Martin A. Marques" wrote:
> >
> > Is there any utilitie (for Linux if it can be) to pass from excell tables to
> > postgres database tables?
>
> You could use Sun's Staroffice to take the Excel files, save them as a
> text file, and then use PostgreSQL COPY features to upload them into a
> database.
>
>
> >
> > Saludos... ;-)
>
> /* Saludos, ch. Sos argentino o Uruguayo, porque conozco un tocayo tuyo
> por ac ...*/
>

--
``````````` Silvio Emanuel Nunes Barbosa de Macedo (PhD Std) '''''''''''''
smacedo(at)ic(dot)ac(dot)uk smacedo(at)inescn(dot)pt
Intelligent and Interactive Systems Telecom. and Multimedia
Imperial College, University of London INESC Porto
Exhibition Road, Pc da Republica, 93
London SW7 2AZ, England 4050-497 Porto Portugal
Tel:+44 171 5946323 Tel:+351 22 2094220