"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