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

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: newbie: excel connection? other ad-hoc query windows client?
Дата
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4850802@ratbert.vale-housing.co.uk
обсуждение исходный текст
Ответ на newbie: excel connection? other ad-hoc query windows client?  (george young <gry@ll.mit.edu>)
Ответы Re: newbie: excel connection? other ad-hoc query windows client?  ("Joshua D. Drake" <jd@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: Christopher Gillin
Дата:
Сообщение: Encoding Issues
Следующее
От: Marko Ristola
Дата:
Сообщение: Re: Snapshot 08.01.0006 available for testing