From: | "Chris Carbaugh" <chris(at)leerelectric(dot)com> |
---|---|
To: | "'Fabrice Scemama'" <fabrices(at)ximmo(dot)ftd(dot)fr>, "'Martin A(dot) Marques'" <martin(at)math(dot)unl(dot)edu(dot)ar> |
Cc: | <pgsql-general(at)hub(dot)org> |
Subject: | RE: excell to postgres |
Date: | 2000-04-17 15:57:53 |
Message-ID: | 001301bfa885$b0e41e80$1901a8c0@leerelectric.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Can't you just export the excel sheets to a character delimited file and
then import that into pgsql?
With a little VB script in excel, you should be able to make pretty
automated. Just create you own "save" method that would save the sheet as
the delimited file is a certain location. Then have a cron job parse the
location for new files.
Just my 2 cents (and man, the bank is hurtin' :)
Chris
> -----Original Message-----
> From: pgsql-general-owner(at)hub(dot)org
> [mailto:pgsql-general-owner(at)hub(dot)org]On
> Behalf Of Fabrice Scemama
> Sent: Monday, April 17, 2000 12:22 PM
> To: Martin A. Marques
> Cc: pgsql-general(at)hub(dot)org
> Subject: Re: [GENERAL] excell to postgres
>
>
> "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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Fabrice Scemama | 2000-04-17 16:21:43 | Re: excell to postgres |
Previous Message | Kristopher Yates | 2000-04-17 15:50:19 | Re: excell to postgres |