newbie: excel connection? other ad-hoc query windows client?

From: george young <gry(at)ll(dot)mit(dot)edu>
To: pgsql-odbc(at)postgresql(dot)org
Subject: newbie: excel connection? other ad-hoc query windows client?
Date: 2005-11-04 21:22:19
Message-ID: 20051104162219.680b1283.gry@ll.mit.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

[ODBC] Snapshot 08.01.0006
Windows XP Pro 2002, SP 1
MS Excel 2002 (10.2614.2625)
Server: Postgresql-7.4RC2 on linux
[linux hacker, I've never used ODBC before, not much windows expertise]

I'm struggling to understand how ODBC is/can be used.

GOAL: I want some easy-to-use windows GUI client that would let
occasional users do ad-hoc viewing, data extraction, plotting,
including a few simple joins(maybe in some transparent way). The
users are hardware engineers, not software/db geeks(like me), and do
not know SQL.

We have *some* canned queries packaged up, but there are too many
slices/joins that users may want.

I had thought to use Excel, since everyone here knows it, and I had
heard that it could access sql databases via odbc. I was able to get
a single table loaded into an Excel sheet, though the data doesn't seem
to be right. Does my table with 34862 rows freak out Excel or ODBC?
We will often be dealing with tables of ~10M rows.

Is there some other windows client (preferably free or part of a
default windows installation) that would do what I need?

-- George Young
--
"Are the gods not just?" "Oh no, child.
What would become of us if they were?" (CSL)

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Joshua D. Drake 2005-11-05 02:33:03 Re: newbie: excel connection? other ad-hoc query windows client?
Previous Message Rainer Bauer 2005-11-04 16:01:04 Re: Snapshot 08.01.0006 available for testing