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