By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Creating Pivot tables

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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-----

Nov 12 '05 #2

P: n/a
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 <me@privacy.com> 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-----

Nov 12 '05 #3

P: n/a
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
Nov 12 '05 #4

P: n/a
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-----

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.