Received: from Kitten.mcs.com (Kitten.mcs.com [192.160.127.90]) by hub.org (8.8.8/8.7.5) with ESMTP id RAA09627; Tue, 25 Aug 1998 17:55:42 -0400 (EDT) Received: from Venus.mcs.net (les@Venus.mcs.net [192.160.127.92]) by Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id QAA05289; Tue, 25 Aug 1998 16:55:42 -0500 (CDT) Received: (from les@localhost) by Venus.mcs.net (8.8.7/8.8.2) id QAA08006; Tue, 25 Aug 1998 16:55:41 -0500 (CDT) From: Leslie Mikesell Message-Id: <199808252155.QAA08006@Venus.mcs.net> Subject: excel vs. money data type? To: pgsql-sql@postgreSQL.org, pgsql-interfaces@postgreSQL.org Date: Tue, 25 Aug 1998 16:55:41 -0500 (CDT) X-Mailer: ELM [version 2.4 PL24] Content-Type: text 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