excel vs. money data type?

From: Leslie Mikesell <les(at)Mcs(dot)Net>
To: pgsql-sql(at)postgreSQL(dot)org, pgsql-interfaces(at)postgreSQL(dot)org
Subject: excel vs. money data type?
Date: 1998-08-25 21:55:41
Message-ID: 199808252155.QAA08006@Venus.mcs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-sql

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(at)mcs(dot)com

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Greg Flanders 1998-08-25 23:49:42 Using Pg's error message
Previous Message Gerald Gryschuk 1998-08-25 21:52:12 Re: [INTERFACES] iodbc interface on Unix

Browse pgsql-sql by date

  From Date Subject
Next Message Walt Bigelow 1998-08-25 22:38:45 copying rows
Previous Message Leslie Mikesell 1998-08-25 20:52:39 Date vs. Datetime boundaries