Re: newbie: excel connection? other ad-hoc query windows client? - Mailing list pgsql-odbc

From Dave Page
Subject Re: newbie: excel connection? other ad-hoc query windows client?
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4850802@ratbert.vale-housing.co.uk
Whole thread Raw
In response to newbie: excel connection? other ad-hoc query windows client?  (george young <gry@ll.mit.edu>)
Responses Re: newbie: excel connection? other ad-hoc query windows client?
List pgsql-odbc


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

pgsql-odbc by date:

Previous
From: Christopher Gillin
Date:
Subject: Encoding Issues
Next
From: Marko Ristola
Date:
Subject: Re: Snapshot 08.01.0006 available for testing