Skip to main content
July 5, 2024
Question

How to Export datastore to Excel if i have multiple table .

  • July 5, 2024
  • 4 replies
  • 0 views

If I have four tables in a database how do I export them in a single sheet of Excel?

1

    4 replies

    stefanhelzle0001
    July 5, 2024

    Create a view in the DB and export from that.

    konduruc733182
    July 5, 2024

    Not sure if you are asking to export all tables in a single grid/sheet or in 4 different sheets. If the first as Stefan mentioned create a view and use it for your requirement. If you want get those in 4 different sheets, and a script post the smart service and increase the counter by 1 and use choose the DSE and use the counter value in the sheet number.

    davidj137213
    July 5, 2024

    It depends on which data you need yo export.. but as Stephan said, the best approach is to create a view in your database , selecting the data you may need

    karumurua531442
    July 6, 2024

    Hi [mention:820556802286420f85753e9006d09c76:e9ed411860ed4f2ba0265705b8793d05] Creating a view and export that into Excel using smart service.