Creating Pivot tables

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Del
    #1

    Creating Pivot tables

    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
    Tags: None
    • MGFoster
      #2
      Re: Creating Pivot tables

      Del wrote:
      [color=blue]
      > 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?[/color]

      -----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:::mgf0 0 <at> earthlink <decimal-point> net
      Oakland, CA (USA)

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

      iQA/AwUBQH7jpIechKq OuFEgEQLAVwCg10 GbcMw575TL9tblz dvCYGCydpoAnid8
      KNo+M6ODdVSssi3 Nj9O9Kj8P
      =OfE3
      -----END PGP SIGNATURE-----

        Comment

        • Del
          #3
          Re: Creating Pivot tables

          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:<tsBfc.117 98$k05.1299@new sread2.news.pas .earthlink.net> ...[color=blue]
          > Del wrote:
          >[color=green]
          > > 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?[/color]
          >
          > -----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:::mgf0 0 <at> earthlink <decimal-point> net
          > Oakland, CA (USA)
          >
          > -----BEGIN PGP SIGNATURE-----
          > Version: PGP for Personal Privacy 5.0
          > Charset: noconv
          >
          > iQA/AwUBQH7jpIechKq OuFEgEQLAVwCg10 GbcMw575TL9tblz dvCYGCydpoAnid8
          > KNo+M6ODdVSssi3 Nj9O9Kj8P
          > =OfE3
          > -----END PGP SIGNATURE-----[/color]

            Comment

            • Bruce
              #4
              Re: Creating Pivot tables

              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

                Comment

                • MGFoster
                  #5
                  Re: Creating Pivot tables

                  Del wrote:
                  [color=blue]
                  > 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.
                  >
                  >[color=green]
                  >>Del wrote:
                  >>
                  >>[color=darkred]
                  >>>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?[/color]
                  >>[/color][/color]
                  < 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:::mgf0 0 <at> earthlink <decimal-point> net
                  Oakland, CA (USA)

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

                  iQA/AwUBQIAnQoechKq OuFEgEQIn+ACbBa nT0U5vU6dpoDPdk ARSK/Rm2ukAoIxl
                  I/Bit/vykJgeCzMfOBnZ/ndM
                  =Pwtf
                  -----END PGP SIGNATURE-----

                    Comment

                    Previous template Next
                    Working...