Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org
	(8.8.8/8.7.5) with ESMTP id JAA24744 for
	<pgsql-interfaces@postgreSQL.org>;
	Wed, 26 Aug 1998 09:13:25 -0400 (EDT)
Received: from insightdist.com (nobody@localhost)
	by u1.abs.net (8.9.0/8.9.0) with UUCP id JAA24975
	for pgsql-interfaces@postgreSQL.org;
	Wed, 26 Aug 1998 09:01:03 -0400 (EDT)
X-Authentication-Warning: u1.abs.net: nobody set sender to
	insightdist.com!daveh using -f
Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03)
	id AA20474; Wed, 26 Aug 1998 08:50:09 -0400
Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03)
	id AA75380; Wed, 26 Aug 1998 08:50:08 -0400
Message-Id: <35E40584.3B11394F@insightdist.com>
Date: Wed, 26 Aug 1998 08:54:28 -0400
From: David Hartwig <daveh@insightdist.com>
Organization: Insight Distribution Systems
X-Mailer: Mozilla 4.05 [en] (Win95; I)
Mime-Version: 1.0
To: Leslie Mikesell <les@Mcs.Net>
Cc: pgsql-sql@postgreSQL.org, pgsql-interfaces@postgreSQL.org,
	Byron Nikolaidis <byronn@insightdist.com>
Subject: Re: [SQL] excel vs. money data type?
References: <199808252155.QAA08006@Venus.mcs.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

This sounds like a bug I came across a while ago.   Since then, I abandon money in
favor of float.   I suspect it has to do with the leading "$" and the a conversion
to a number.   It looks like it has slipped through the proverbial crack.   In any
case, it will be about a week until this can be addressed.


Leslie Mikesell wrote:

> Is there any way to get a pgsql MONEY data type into excel (office 95 version)
> using the odbc driver?  I can see the values in the preview doing the
> query but they come in as zeros when I click the 'Return Data to
> Microsoft Excel' menu.  I can get them in Access and export the table
> to an Excel file but I want a canned query that someone else can
> run using only Excel.
>