| From: | David Hartwig <daveh(at)insightdist(dot)com> |
|---|---|
| To: | Leslie Mikesell <les(at)Mcs(dot)Net> |
| Cc: | pgsql-sql(at)postgreSQL(dot)org, pgsql-interfaces(at)postgreSQL(dot)org, Byron Nikolaidis <byronn(at)insightdist(dot)com> |
| Subject: | Re: [SQL] excel vs. money data type? |
| Date: | 1998-08-26 12:54:28 |
| Message-ID: | 35E40584.3B11394F@insightdist.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces pgsql-sql |
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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Byron Nikolaidis | 1998-08-26 13:25:00 | Re: [INTERFACES] iodbc interface on Unix |
| Previous Message | David Hartwig | 1998-08-26 12:47:12 | Re: [INTERFACES] new odbc fails |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Leslie Mikesell | 1998-08-26 15:15:44 | Re: [SQL] excel vs. money data type? |
| Previous Message | Herouth Maoz | 1998-08-26 08:57:16 | Re: [SQL] parts of date_part() |