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

[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)

>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?
>
>

Microsoft Access with linked tables?

>-- George Young
>
>


--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org on behalf of george young
Sent: Fri 11/4/2005 9:22 PM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] newbie: excel connection? other ad-hoc query windows client?

> 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.

Excel can only handle 32768 rows in a sheet iirc. You might try plain old MS Query which you should find somewhere in
yourOffice installation, though probably without a shortcut. 

Regards, Dave.

Dave Page wrote:

>
> Excel can only handle 32768 rows in a sheet iirc.

Although this doesn't solve the problem, just FYI I believe it is 65536.

Sincerely,

Joshua D. Drake