# How to read/write in ODBC by using node red

**URL:** <https://discourse.nodered.org/t/how-to-read-write-in-odbc-by-using-node-red/70648>\
**Category:** General\
**Tags:** database, mqtt\
**Created:** [15 November 2022 13:11 UTC](https://discourse.nodered.org/t/how-to-read-write-in-odbc-by-using-node-red/70648 "2022-11-15T13:11:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![haladriel](https://avatars.discourse-cdn.com/v4/letter/h/22d042/32.png) [@haladriel](https://discourse.nodered.org/u/haladriel)\
**Post date:** [15 November 2022 13:11 UTC](https://discourse.nodered.org/t/how-to-read-write-in-odbc-by-using-node-red/70648/1 "2022-11-15T13:11:33Z")

</div>

Hello everyone.

I have an application where i need to log the data in MS Access and later from other table i need to read other data.

I already created the ODBC source and can write/ read on it with MS Access.

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/4/a406ef1f9500f8efd770f86d3b6999aa494eb5e3.png)

My Problem is that i can not send/ write data in the ODBC table with node-red and i also dont know how i can find and set my connection from the ODBC source. My idear was to use a ODBC query

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/2/e267c31fa659f843ad2f656119d686cf7fb9030a.png)

Can someone tell me how i can integrate this in node-red?

Thanks for any help.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [14 January 2023 13:11 UTC](https://discourse.nodered.org/t/how-to-read-write-in-odbc-by-using-node-red/70648/2 "2023-01-14T13:11:39Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.