Re: excell to postgres - Mailing list pgsql-general

From Bruce Momjian
Subject Re: excell to postgres
Date
Msg-id 200004171548.LAA09560@candle.pha.pa.us
Whole thread Raw
In response to Re: excell to postgres  (Haroldo Stenger <hstenger@adinet.com.uy>)
Responses Re: excell to postgres  ("Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>)
List pgsql-general
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> "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.

Try xlHtml at http://www.gate.net/~ddata/xlHtml/index.htm.  This
converts Excel to HTML.  Very nice.  I then convert it to text using
other tools.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: "Kristopher Yates"
Date:
Subject: Re: excell to postgres
Next
From: "Chris Carbaugh"
Date:
Subject: RE: excell to postgres