Re: excell to postgres

From: "Kristopher Yates" <kyates(at)wspice(dot)com>
To: Fabrice Scemama <fabrices(at)ximmo(dot)ftd(dot)fr>
Cc: pgsql-general(at)hub(dot)org
Subject: Re: excell to postgres
Date: 2000-04-17 15:50:19
Message-ID: 200004171550.LAA40031@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I dont know of anything like that but you should be able to write
one in PHP. What I normally do is export from the original
database format to a tab delimited text file and then I write a PHP
(or whatever) utility that converts a tab delimited file to the PSQL
format.

On 17 Apr 00, at 17:21, Fabrice Scemama wrote:

> "Martin A. Marques" wrote:
> >
> > Is there any utilitie (for Linux if it can be) to pass from excell tables to
> > postgres database tables?
> >
> > Saludos... ;-)
> >
> > --
> > "And I'm happy, because you make me feel good, about me." - Melvin Udall
> > -----------------------------------------------------------------
> > Martín Marqués email: martin(at)math(dot)unl(dot)edu(dot)ar
> > Santa Fe - Argentina http://math.unl.edu.ar/~martin/
> > Administrador de sistemas en math.unl.edu.ar
> > -----------------------------------------------------------------
>
> You might use C OLE -- a C lib which was designed so as to
> import OLE files to other formats. An application is xlHTML
> (excel to HTML). I use xlHTML to import excel tables, then
> convert the HTML to DBF using a perl script. For some reason,
> xlHTML's author did not code a xlDBF file; and I'm not familiar
> with C. I'd be interested in something better than my
> solution (which I can send to you if you wish so).
>
> xlHTML:
> http://www.gate.net/~ddata/xlHtml/index.htm
>
> Regards
> Fabrice Scemama
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Carbaugh 2000-04-17 15:57:53 RE: excell to postgres
Previous Message Margarita Barvinok 2000-04-17 15:48:57 Re: Connecting website with SQL-database.....