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

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org on behalf of george young
Sent: Fri 11/4/2005 9:22 PM
To: pgsql-odbc(at)postgresql(dot)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 your Office installation, though probably without a shortcut.

Regards, Dave.