Received: from Kitten.mcs.com (Kitten.mcs.com [192.160.127.90]) by hub.org
	(8.8.8/8.7.5) with ESMTP id LAA03420;
	Wed, 26 Aug 1998 11:15:49 -0400 (EDT)
Received: from Venus.mcs.net (les@Venus.mcs.net [192.160.127.92]) by
	Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id KAA15099;
	Wed, 26 Aug 1998 10:15:45 -0500 (CDT)
Received: (from les@localhost) by Venus.mcs.net (8.8.7/8.8.2) id KAA17042;
	Wed, 26 Aug 1998 10:15:45 -0500 (CDT)
From: Leslie Mikesell <les@Mcs.Net>
Message-Id: <199808261515.KAA17042@Venus.mcs.net>
Subject: Re: [SQL] excel vs. money data type?
To: daveh@insightdist.com (David Hartwig)
Date: Wed, 26 Aug 1998 10:15:44 -0500 (CDT)
Cc: les@Mcs.Net, pgsql-sql@postgreSQL.org, pgsql-interfaces@postgreSQL.org,
	byronn@insightdist.com
In-Reply-To: <35E40584.3B11394F@insightdist.com> from "David Hartwig" at Aug
	26, 98 08:54:28 am
X-Mailer: ELM [version 2.4 PL24]
Content-Type: text

According to David Hartwig:
> 
> 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.

Thank you.  The weird thing is that the numbers show up in the preview as you
build the query, and access gets the values (but loses the money formatting).  It
is only the 'return to excel' step that loses the numbers.

  Les Mikesell
   les@mcs.com