# iNSERT CSV DATA IN MS ACCESS

**URL:** <https://discourse.nodered.org/t/insert-csv-data-in-ms-access/1985>\
**Category:** General\
**Created:** [1 August 2018 19:50 UTC](https://discourse.nodered.org/t/insert-csv-data-in-ms-access/1985 "2018-08-01T19:50:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rbauwens3263](https://avatars.discourse-cdn.com/v4/letter/r/d07c76/32.png) [@rbauwens3263](https://discourse.nodered.org/u/rbauwens3263)\
**Post date:** [1 August 2018 19:50 UTC](https://discourse.nodered.org/t/insert-csv-data-in-ms-access/1985/1 "2018-08-01T19:50:23Z")

</div>

I am trying to insert an CSV string into an MS ACCESS DB-Base - any idea which NODE to use ?

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [1 August 2018 20:27 UTC](https://discourse.nodered.org/t/insert-csv-data-in-ms-access/1985/2 "2018-08-01T20:27:59Z")

</div>

You can search the majority of nodes on [flows.nodered.org](http://flows.nodered.org)

---

<div class="post-metadata">

**Author:** ![realjax](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/realjax/32/895_2.png) [@realjax](https://discourse.nodered.org/u/realjax)\
**Post date:** [1 August 2018 20:32 UTC](https://discourse.nodered.org/t/insert-csv-data-in-ms-access/1985/3 "2018-08-01T20:32:53Z")

</div>

You need to set up the access dbase though an appropriate ODBC driver. Then find a node that can connect to it and create a SQL statement out of you CSV string. But I'd simply write the string to a text file and then open that in excell and take it from there. Much easier. Or not use Access at all, an even better advice 🙂