Creating Pivot tables

[Del]

I need to create Pivot table in Excel from Access.
Currently I run a query and output the data to an excel worksheet and
create the pivots via automation.

The issue I face is that the query may return more than 65000 rows of
data. Is there a way I can create the Pivot tables without having to
output the data to excel first?

Any help would be appreciated.

Thanks

Del

[MGFoster]

Del wrote:

I need to create Pivot table in Excel from Access.
Currently I run a query and output the data to an excel worksheet and
create the pivots via automation.

The issue I face is that the query may return more than 65000 rows of
data. Is there a way I can create the Pivot tables without having to
output the data to excel first?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Pivot Tables in Access are also called cross-tab queries. If you just
want the results in Excel you can create the cross-tab query (use the
cross-tab query wizard) in Access and export the results to Excel.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQH7jpIechKqOuFEgEQLAVwCg10GbcMw575TL9tblzdvCYG CydpoAnid8
KNo+M6ODdVSssi3Nj9O9Kj8P
=OfE3
-----END PGP SIGNATURE-----

[Del]

Thanks for you response. I have explore the Cross tab route and
unfortunately the users want more flexibility and want to be able to
manipulate and filter the data in their spreadsheet.
Thx anyway.
MGFoster <[e-mail]> wrote in message news:<ts******************@newsread2.news.pas.eart hlink.net>...

Del wrote:

I need to create Pivot table in Excel from Access.
Currently I run a query and output the data to an excel worksheet and
create the pivots via automation.

The issue I face is that the query may return more than 65000 rows of
data. Is there a way I can create the Pivot tables without having to
output the data to excel first?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Pivot Tables in Access are also called cross-tab queries. If you just
want the results in Excel you can create the cross-tab query (use the
cross-tab query wizard) in Access and export the results to Excel.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQH7jpIechKqOuFEgEQLAVwCg10GbcMw575TL9tblzdvCYG CydpoAnid8
KNo+M6ODdVSssi3Nj9O9Kj8P
=OfE3
-----END PGP SIGNATURE-----

[Bruce]

You may wish to look at the Office 2002/2003 version of Access as it
uses the Office Component Pivot Table instead of creating the Excel
verison.
I personally prefer the Excel version (see my April 14 posting), but
the Access 2003 version may suit your needs.
Bruce

[MGFoster]

Del wrote:

Thanks for you response. I have explore the Cross tab route and
unfortunately the users want more flexibility and want to be able to
manipulate and filter the data in their spreadsheet.
Thx anyway.

Del wrote:

I need to create Pivot table in Excel from Access.
Currently I run a query and output the data to an excel worksheet and
create the pivots via automation.

The issue I face is that the query may return more than 65000 rows of
data. Is there a way I can create the Pivot tables without having to
output the data to excel first?

< SNIP previous post >

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It's been a while since I've used Excel but I believe Excel can read/run
Access queries (those that don't use Access VBA functions & built-in
functions) as the data source for Pivot Tables.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQIAnQoechKqOuFEgEQIn+ACbBanT0U5vU6dpoDPdkARSK/Rm2ukAoIxl
I/Bit/vykJgeCzMfOBnZ/ndM
=Pwtf
-----END PGP SIGNATURE-----