pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedexcel vs. money data type?
3+ messages / 2 participants
[nested] [flat]
* excel vs. money data type?
@ 1998-08-25 21:55 Leslie Mikesell <les@Mcs.Net>
0 siblings, 1 reply; 3+ messages in thread
From: Leslie Mikesell @ 1998-08-25 21:55 UTC (permalink / raw)
To: pgsql-sql@postgreSQL.org; pgsql-interfaces
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.
Les Mikesell
les@mcs.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] excel vs. money data type?
@ 1998-08-26 12:54 David Hartwig <daveh@insightdist.com>
parent: Leslie Mikesell <les@Mcs.Net>
0 siblings, 1 reply; 3+ messages in thread
From: David Hartwig @ 1998-08-26 12:54 UTC (permalink / raw)
To: Leslie Mikesell <les@Mcs.Net>; +Cc: pgsql-sql@postgreSQL.org, pgsql-interfaces@postgreSQL.org, Byron Nikolaidis <byronn@insightdist.com>
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.
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] excel vs. money data type?
@ 1998-08-26 15:15 Leslie Mikesell <les@Mcs.Net>
parent: David Hartwig <daveh@insightdist.com>
0 siblings, 0 replies; 3+ messages in thread
From: Leslie Mikesell @ 1998-08-26 15:15 UTC (permalink / raw)
To: daveh@insightdist.com; +Cc: les@Mcs.Net; pgsql-sql@postgreSQL.org; pgsql-interfaces; byronn@insightdist.com
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-08-26 15:15 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-08-25 21:55 excel vs. money data type? Leslie Mikesell <les@Mcs.Net>
1998-08-26 12:54 ` David Hartwig <daveh@insightdist.com>
1998-08-26 15:15 ` Leslie Mikesell <les@Mcs.Net>
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