Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    660

    Unanswered: How to import the total value in the report to a exiting excell

    I have a report that show the total and grand total for all the categories. But the use would like to import all these value to their existing spread sheet with particular cell automatically. Is that any way to do it? Many thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,420
    Provided Answers: 7
    I only way I know is to create a query grouping by the Categories and summing the totals them useing a OBDC and link from the excel sheet to that query
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Mar 2004
    Posts
    660
    Thanks, Could you please tell me how to link from excel to that query? I think that will work for me. Thanks again.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Are we simply talking about the DoCmd.TransferSpreadsheet method? Look up TransferSpreadsheet in the help files and see if it does what you want.

    Alternatively; pootle flump has posted something in the code bank regarding Access and Excel links - it may be another useful place to take a look
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •