Re: excell to postgres

I'm a Linux user.
I've been using xlHTML and a home-made HTML2DBF rather than
ODBC with Perl's DBD::Proxy and DBD::ODBC because, to be
able to use ODBC, you need people to *name* the table they
create when using Excel. Well, they never do so.
Sometimes, they will name a table with 256 columns and
thousands of rows! and this, will *not* be handled by
stupid ODBC. No name being given to define the table will
make ODBC fail, as well.

You can open the file, then save it as CSV, etc.
But don't we want to make these kinds of things automatic?

That's why I use xlHTML. And yes, even with it, I come
across bad surprises, very often. So often that I've been
in the obligation to refuse that people send me Excel tables.
Access is the maximum I can tolerate (ODBC is ok at least).

Fabrice Scemama

Chris Carbaugh wrote:
>
> 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
> >

--
"How could this be a problem in a country where we have Intel and
Microsoft?" (Al Gore, Vanity Fair, January 1999 issue, talking about
Y2K)