Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009

    Unanswered: Output/Export a report or query to tabbed Excel spreadsheet

    Hi I have a fairly simple staff database, one of the staff fields denotes the area they are based in.
    I'd like to output a report and or query for all staff to a single Excel workbook in such a way that the workbook automatically ends up with 6 worksheets, each one labelled as per the 6 possible areas and with only the staff based in that area on that specfic worksheet.
    So all staff exported to 1 Excel workbook sorted onto 6 seperate worksheets.
    Using Access 2000 and Excel 2002, bit of a novice so simply explained if possible.
    Any help much appreciated

  2. #2
    Join Date
    Apr 2004
    metro Detroit
    Check the code bank. Pootle posted a nice collection of excel automation samples.

  3. #3
    Join Date
    Jul 2009
    thanks will do , have looked but will look again more carefully

Posting Permissions

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