# Automation script, select to file as HTML table

**URL:** <https://forums.toadworld.com/t/automation-script-select-to-file-as-html-table/28737>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [February 10, 2014, 12:20pm UTC](https://forums.toadworld.com/t/automation-script-select-to-file-as-html-table/28737 "2014-02-10T12:20:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![andy.corson](https://avatars.discourse-cdn.com/v4/letter/a/ecd19e/32.png) [@andy.corson](https://forums.toadworld.com/u/andy.corson)\
**Post date:** [February 10, 2014, 12:20pm UTC](https://forums.toadworld.com/t/automation-script-select-to-file-as-html-table/28737/1 "2014-02-10T12:20:01Z")

</div>

I created an automation script to export results of a system table query showing each table in the database and the number of rows. However, when I export it to HTML, only the headers show up. Is there another step to getting the data into an HTML table?

---

<div class="post-metadata">

**Author:** ![andy.corson](https://avatars.discourse-cdn.com/v4/letter/a/ecd19e/32.png) [@andy.corson](https://forums.toadworld.com/u/andy.corson)\
**Post date:** [February 10, 2014, 12:26pm UTC](https://forums.toadworld.com/t/automation-script-select-to-file-as-html-table/28737/2 "2014-02-10T12:26:00Z")

</div>

For some reason it worked fine when I selected the query file as opposed to just pasting in the sql.