Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Output to Spreadsheet

Discussion in 'Information Technology' started by millardgroups@gmail.com, Jul 28, 2006.

  1. millardgroups@gmail.com

    millardgroups@gmail.com
    Expand Collapse
    Guest

    I have a query that returns a single row of summary data. I need to
    export it to Excel when a user clicks a button. When it exports, I need
    the output to run vertically rather than horizontally.

    That is, instead of:
    Header1 | Header2 | Header3 | Header4 | Header5 ... etc
    Result1 | Result 2 | Result3 | Result4 | Result5 ... etc

    I need:
    Header1 | Result1
    Header2 | Result2
    Header3 | Result3
    Header4 | Result4
    Header5 | Result5
    etc...

    Can you suggest the best way to do this?

    Thanks!

    Scott
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Punjab wheat output to be highest in 7 years (Reuters via Yahoo! India News) Breaking News May 15, 2008
    Sikh News Punjab fears shortfall of 2.4m tons in wheat output (Dawn) Breaking News Apr 7, 2008
    Sikh News Punjab fastener makers trim output by 30% on rising cost (The Hindu) Breaking News Mar 10, 2008

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    millardgroups@gmail.com wrote:
    > I have a query that returns a single row of summary data. I need to
    > export it to Excel when a user clicks a button. When it exports, I
    > need the output to run vertically rather than horizontally.
    >
    > That is, instead of:
    > Header1 | Header2 | Header3 | Header4 | Header5 ... etc
    > Result1 | Result 2 | Result3 | Result4 | Result5 ... etc
    >
    > I need:
    > Header1 | Result1
    > Header2 | Result2
    > Header3 | Result3
    > Header4 | Result4
    > Header5 | Result5
    > etc...
    >
    > Can you suggest the best way to do this?
    >
    > Thanks!
    >
    > Scott


    Crosstab query?

    --
    Joseph Meehan

    Dia duit
     
  4. millardgroups@gmail.com

    millardgroups@gmail.com
    Expand Collapse
    Guest

    Thanks!

    Dia is Muire duit

    Joseph Meehan wrote:
    > millardgroups@gmail.com wrote:
    > > I have a query that returns a single row of summary data. I need to
    > > export it to Excel when a user clicks a button. When it exports, I
    > > need the output to run vertically rather than horizontally.
    > >
    > > That is, instead of:
    > > Header1 | Header2 | Header3 | Header4 | Header5 ... etc
    > > Result1 | Result 2 | Result3 | Result4 | Result5 ... etc
    > >
    > > I need:
    > > Header1 | Result1
    > > Header2 | Result2
    > > Header3 | Result3
    > > Header4 | Result4
    > > Header5 | Result5
    > > etc...
    > >
    > > Can you suggest the best way to do this?
    > >
    > > Thanks!
    > >
    > > Scott

    >
    > Crosstab query?
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
     
  5. kerry_ja@yahoo.com

    kerry_ja@yahoo.com
    Expand Collapse
    Guest

    millardgroups@gmail.com wrote:
    > I have a query that returns a single row of summary data. I need to
    > export it to Excel when a user clicks a button. When it exports, I need
    > the output to run vertically rather than horizontally.
    >
    > That is, instead of:
    > Header1 | Header2 | Header3 | Header4 | Header5 ... etc
    > Result1 | Result 2 | Result3 | Result4 | Result5 ... etc
    >
    > I need:
    > Header1 | Result1
    > Header2 | Result2
    > Header3 | Result3
    > Header4 | Result4
    > Header5 | Result5
    > etc...
    >
    > Can you suggest the best way to do this?
    >
    > Thanks!
    >
    > Scott


    How about exporting it to Excel, and then calling Excel from Access to
    copy and paste transposed?
     
  6. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

    how about not letting the grubby spreadsheet retards to be able to use
    your data.

    keep your data in a database; spit on anyone that tells you otherwise


    kerry_ja@yahoo.com wrote:
    > millardgroups@gmail.com wrote:
    > > I have a query that returns a single row of summary data. I need to
    > > export it to Excel when a user clicks a button. When it exports, I need
    > > the output to run vertically rather than horizontally.
    > >
    > > That is, instead of:
    > > Header1 | Header2 | Header3 | Header4 | Header5 ... etc
    > > Result1 | Result 2 | Result3 | Result4 | Result5 ... etc
    > >
    > > I need:
    > > Header1 | Result1
    > > Header2 | Result2
    > > Header3 | Result3
    > > Header4 | Result4
    > > Header5 | Result5
    > > etc...
    > >
    > > Can you suggest the best way to do this?
    > >
    > > Thanks!
    > >
    > > Scott

    >
    > How about exporting it to Excel, and then calling Excel from Access to
    > copy and paste transposed?
     
  7. millardgroups@gmail.com

    millardgroups@gmail.com
    Expand Collapse
    Guest

    Thanks... That sounds like a clean way to do it... can you suggest some
    starting code that would make this happen?

    kerry_ja@yahoo.com wrote:
    > millardgroups@gmail.com wrote:
    > > I have a query that returns a single row of summary data. I need to
    > > export it to Excel when a user clicks a button. When it exports, I need
    > > the output to run vertically rather than horizontally.
    > >
    > > That is, instead of:
    > > Header1 | Header2 | Header3 | Header4 | Header5 ... etc
    > > Result1 | Result 2 | Result3 | Result4 | Result5 ... etc
    > >
    > > I need:
    > > Header1 | Result1
    > > Header2 | Result2
    > > Header3 | Result3
    > > Header4 | Result4
    > > Header5 | Result5
    > > etc...
    > >
    > > Can you suggest the best way to do this?
    > >
    > > Thanks!
    > >
    > > Scott

    >
    > How about exporting it to Excel, and then calling Excel from Access to
    > copy and paste transposed?
     

Share This Page