Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Apple Message framework v1251.1)
Subject: Re: i want small information regarding postgres
From: Brent Dombrowski <brent.dombrowski@gmail.com>
In-Reply-To: <20120102080022.GA4898@tux>
Date: Mon, 2 Jan 2012 11:13:49 -0800
Content-Transfer-Encoding: quoted-printable
Message-Id: <CF7C9AAC-2172-40EB-8FC8-E44019F6C443@gmail.com>
References: 
 <CAONL4YXmnOEg1_bjK9fV74sc=4dD0iAKeGqvwjL5M89AHbO2MA@mail.gmail.com>
	<20120102080022.GA4898@tux>
To: pgsql-sql <pgsql-sql@postgresql.org>


On Jan 2, 2012, at 12:00 AM, Andreas Kretschmer wrote:

> vinodh chowdary <vinodchowdary9@gmail.com> wrote:
>=20
>> Hi sir,
>>=20
>> i am using postgres as database for  my project.
>> i want to convert postgres data into excel sheet.
>> is there any way to do it?
>> please reply me.
>=20
> This should be possible with ODBC.
> (But i'm not familiar with it, don't ask me how ...)

I've used ODBC to generate Excel reports from PostgreSQL data in the =
past. It's fairly easy for simple queries. If your queries are =
complicated, you may have to execute them from a Visual Basic Macro. The =
MS query builder will try to check raw SQL and may reject your query =
because it's not that smart. In particular, I had trouble with stored =
procedures in my queries. If it is something that you plan on doing =
routinely, I would set up a macro and a keyboard shortcut or button so =
you can run the macro quickly and easily.