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

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