Re: postgresql ODBC access question

"Elford, Andrew [Ontario]" wrote:

>   Surely, there's a way to connect to a postgresql database and export the
> data directly from excel (or any ODBC enabled program) into a database?  Am
> i barking up the wrong tree here?

Since I don't know anything about ODBC or Excel, I'd suggest you to ask
another person.
I just had the impression that you had already tried with ODBC (remember you
filed a critical bug).
So I offered you a way to bypass ODBC and Excel.

I don't know anything about this subject. Please ask on the pgsql-interfaces
mailing list (I cc'ed it).

Christof


> *       From: Christof Petig < christof.petig@wtal.de
> <mailto:christof.petig@wtal.de> >
>
> *       To: martinkuria@hotmail.com <mailto:martinkuria@hotmail.com> ,
> pgsql-bugs@postgresql.org <mailto:pgsql-bugs@postgresql.org>
>
> *       Subject: Re: how to copy data from excel spreadsheet to postgresql
> database
>
> *       Date: Fri, 29 Sep 2000 19:21:55 +0200
>
>   _____
>
> pgsql-bugs@postgresql.org wrote:
>
> > Martin Kuria (martinkuria@hotmail.com) reports a bug with a severity of 1
>
> > The lower the number the more severe it is.
>
> Bug? severe?
>
> But I will undertake to answer you though.
>
> > Short Description
>
> > how to copy data from excel spreadsheet to postgresql database
>
> >
>
> > Long Description
>
> > I have enter data in excel spreadsheet, and I would like to enter or copy
> this data in my postgresql database, please do give a example, thanks
>
> >
>
> > best regards
>
> > martin.
>
> >
>
> > Sample Code
>
> > explain more on how how a copy command is used, please illustrate with an
> example
>
> >
>
> > No file was uploaded with this report
>
> Do you know SQL? If not, read Bruce's Book.
>
> Export as ASCII, seperated by TABS.
>
> Then precede it by 'copy yourtable from stdin;'
>
> Add '\.' as the last line.
>
> Feed it into postgres:
>
>    psql <yourfile yourdatabase