Export three tables into one excel spreadsheet.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • KailashJa
    New Member
    • Aug 2020
    • 1

    Export three tables into one excel spreadsheet.

    I have three tables and would like to export them into one excel sheet. One table will be from column a to e and second will start from column g and third table from k.
    Please let me know if it is possible.
  • isladogs
    Recognized Expert Moderator Contributor
    • Jul 2007
    • 483

    #2
    Have you tried creating a query which combines the data in your intended layout then exporting that to Excel?

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32662

      #3
      Originally posted by KailashJa
      KailashJa:
      Please let me know if it is possible.
      Yes. It is.

      Isladogs has explained exactly what you need to be looking at to get such a result.

      Welcome to Bytes.com and good luck.

      Comment

      • Naheedmir
        New Member
        • Jul 2020
        • 62

        #4
        Go to Tools, then Database Export > Select a directory > select multiple files > select Excel. Pick up all tables you want to export to excel and click on add filters. With a filter, you can ‘filter’ out the columns you don’t want to export for each table. Click ok.

        Comment

        Working...