From: David Hartwig <daveh@insightdist.com>
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?
Date: Wed, 26 Aug 1998 08:54:28 -0400
Message-ID: <35E40584.3B11394F@insightdist.com> (raw)
References: <199808252155.QAA08006@Venus.mcs.net>
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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: daveh@insightdist.com, les@Mcs.Net, byronn@insightdist.com
Subject: Re: [SQL] excel vs. money data type?
In-Reply-To: <35E40584.3B11394F@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox