Large Pivot Tables

I have a data source with 165000 rows that I would like to make into a Pivot
Table, but it exceeds Excels 65K row limit. Any suggestions would be
appreciated/.

Ken
Tue Mar 15 17:54:13 CST 2005

If you have Access then throw it in there and query it from Excel using Data
/ Get External data

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Richard Mogy" <rmogy@sbcglobal.net> wrote in message
news:W7KZd.10995$C47.4702@newssvr14.news.prodigy.com...
> I have a data source with 165000 rows that I would like to make into a
Pivot
> Table, but it exceeds Excels 65K row limit. Any suggestions would be
> appreciated/.
>
>

Richard
Tue Mar 15 22:42:42 CST 2005

Unfortunately, that's what I thought you'd say.

But I don't understand one thing -- the data is on a SQL Server database.
When I try to query that into Excel using the Pivot Table Wizard as a guide,
it fails. Why would querying it from an Access database succeed?

Just curious, not trying to be argumentative.

Rich
"Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
news:O%23RBMpbKFHA.1176@TK2MSFTNGP15.phx.gbl...
> If you have Access then throw it in there and query it from Excel using
> Data
> / Get External data
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "Richard Mogy" <rmogy@sbcglobal.net> wrote in message
> news:W7KZd.10995$C47.4702@newssvr14.news.prodigy.com...
>> I have a data source with 165000 rows that I would like to make into a
> Pivot
>> Table, but it exceeds Excels 65K row limit. Any suggestions would be
>> appreciated/.
>>
>>
>
>

Ken
Wed Mar 16 16:29:37 CST 2005

If it's on SQL then I would have thought you could access it using Data /
Import External Data / New Database Query / Databases Tab - New data Source,
give it a name and then choose the SQL Server driver and then choose a
server, but I've never done it to be honest. It certainly works fine with
Access as I always do it when I run out of rows, though have never had to go
much more than 250K records. You use the Import Exterrnal Data option and
then choose a Pivot Table as the output.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

<snip>