Re: converting .xls to delimited file

From: Martin Lillepuu <martin(dot)lillepuu(at)mail(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: converting .xls to delimited file
Date: 2001-01-10 22:20:43
Message-ID: 3A5CE03B.DFB2A609@mail.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

William Staniewicz wrote:
>
> Is there any way to convert an Excel file (".xls")
> to a delimited file? Maybe using sed?

forgot to mention, if you are using static filename/one time process you
could setup excel file as odbc datasource on windows computer and access
it via unixODBC (or some equivalent) on unix box. or the other way
around, send data from excel to postgres via postgres odbc interface.

--
Martin Lillepuu | E-mail: martin(dot)lillepuu(at)mail(dot)ee | GSM: 051 56 450

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Uckun 2001-01-10 22:30:50 RE: xml middleware
Previous Message Franck Martin 2001-01-10 22:14:23 RE: xml middleware

Browse pgsql-novice by date

  From Date Subject
Next Message D. Duccini 2001-01-11 00:05:35 Release connections in MODPERL
Previous Message Martin Lillepuu 2001-01-10 22:13:34 Re: converting .xls to delimited file