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.
>