Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-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

pgsql-interfaces by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group