# Import and export table data

**URL:** <https://forum.inductiveautomation.com/t/import-and-export-table-data/72066>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 5, 2023, 4:37am UTC](https://forum.inductiveautomation.com/t/import-and-export-table-data/72066 "2023-04-05T04:37:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![KEERTHANA\_HEMANTH](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/keerthana_hemanth/32/42024_2.png) [@KEERTHANA\_HEMANTH](https://forum.inductiveautomation.com/u/KEERTHANA_HEMANTH)\
**Post date:** [April 5, 2023, 4:37am UTC](https://forum.inductiveautomation.com/t/import-and-export-table-data/72066/1 "2023-04-05T04:37:01Z")

</div>

Hi I have a perspective table component which is bound to a named query that fetches data from SQL database.  
Is there any way to make the Perspective table component editable to alter the data of the table which will also update the SQL database table directly.

---

<div class="post-metadata">

**Author:** ![jonathan.taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jonathan.taylor/32/4048_2.png) [@jonathan.taylor](https://forum.inductiveautomation.com/u/jonathan.taylor)\
**Post date:** [April 5, 2023, 8:03am UTC](https://forum.inductiveautomation.com/t/import-and-export-table-data/72066/2 "2023-04-05T08:03:00Z")

</div>

Yes. If you create the column records in the properties of the table you can make the cells editable.

Then, when the cell is edited you can trigger a named query to update the database for that record. Or you can wait for all the cells to be edited and have a button to update all changed records.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 5, 2023, 11:56am UTC](https://forum.inductiveautomation.com/t/import-and-export-table-data/72066/3 "2023-04-05T11:56:15Z")

</div>

> [@KEERTHANA\_HEMANTH](#):
>
> also update the SQL database table directly.

No, the component cannot do this for you. You must script the handling of edited data to produce/execute the necessary SQL `UPDATE ...` statement, and then refresh the query binding to show the result in your UI.