# Read a csv file to save in SQL

**URL:** <https://forum.inductiveautomation.com/t/read-a-csv-file-to-save-in-sql/16631>\
**Category:** Ignition\
**Created:** [January 17, 2018, 10:12pm UTC](https://forum.inductiveautomation.com/t/read-a-csv-file-to-save-in-sql/16631 "2018-01-17T22:12:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rigoberto.reyes](https://avatars.discourse-cdn.com/v4/letter/r/65b543/32.png) [@rigoberto.reyes](https://forum.inductiveautomation.com/u/rigoberto.reyes)\
**Post date:** [January 17, 2018, 10:12pm UTC](https://forum.inductiveautomation.com/t/read-a-csv-file-to-save-in-sql/16631/1 "2018-01-17T22:12:44Z")

</div>

Hi there.

Can anybody help me?. I need to collect registers from a CSV file (PC) to save it in SQL. Do I mus to use any database connection or driver?. The PC is connected to our LAN.

Thanks.

---

<div class="post-metadata">

**Author:** ![accyroy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/accyroy/32/3386_2.png) [@accyroy](https://forum.inductiveautomation.com/u/accyroy)\
**Post date:** [January 19, 2018, 8:59am UTC](https://forum.inductiveautomation.com/t/read-a-csv-file-to-save-in-sql/16631/2 "2018-01-19T08:59:10Z")

</div>

I’d suggest connecting the Gateway to a shared folder containing the CSV file and use scripting to parse the CSV into tags. Then use transaction groups to insert into the database.  
If you do a search of the forum for CSV there are plenty of scripting examples.