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

    Unanswered: Export contents of 2 tables in single Excel spreadsheet

    I've created a form that takes info from 2 tables which are joined. I'd like to export both the tables into a single excel sheet with some color coding. I want to accomplish the following:
    Export the 2 tables into a single excel sheet and the exported sheet should have a color legend.

    Is this doable? - Gina Grafilo

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Have a look at Pootle's post in the code bank for exporting excel, with that you can do pretty much anything you want with an Excel sheet. If you need help developing the code for your "legend" then I would suggest using Excel to create a macro and then adapting that code to Access.
    Me.Geek = True

Posting Permissions

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