# How to read/write in MS Access table by using node red

**URL:** <https://discourse.nodered.org/t/how-to-read-write-in-ms-access-table-by-using-node-red/70380>\
**Category:** General\
**Tags:** database\
**Created:** [10 November 2022 08:33 UTC](https://discourse.nodered.org/t/how-to-read-write-in-ms-access-table-by-using-node-red/70380 "2022-11-10T08:33:37Z")\
**Posts on this page:** 11\
**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:** [10 November 2022 08:33 UTC](https://discourse.nodered.org/t/how-to-read-write-in-ms-access-table-by-using-node-red/70380/1 "2022-11-10T08:33:37Z")

</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.

But i am not getting any node related to MS Access. I have the Description, the UID, Database name and table but i dont know how i can send Data (csv) to this Table.

I tried to use ODBC tool but i couldn´t find an good explanation how i should code it so that i can write and read from a table from MS Access.

Thanks for any help.

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [10 November 2022 11:50 UTC](https://discourse.nodered.org/t/how-to-read-write-in-ms-access-table-by-using-node-red/70380/2 "2022-11-10T11:50:25Z")

</div>

> [@haladriel](#):
>
> I tried to use ODBC tool but i couldn´t find an good explanation how i should code it so that i can write and read from a table from MS Access.

Are you wanting to do this on Windows or Linux?

---

<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:** [10 November 2022 12:08 UTC](https://discourse.nodered.org/t/how-to-read-write-in-ms-access-table-by-using-node-red/70380/3 "2022-11-10T12:08:06Z")

</div>

Windows if this is possible

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [10 November 2022 12:09 UTC](https://discourse.nodered.org/t/how-to-read-write-in-ms-access-table-by-using-node-red/70380/4 "2022-11-10T12:09:44Z")

</div>

Yes, that is fairly straight-forwards.

This page tells you how to set up the ODBC driver: [Administer ODBC data sources (microsoft.com)](https://support.microsoft.com/en-us/office/administer-odbc-data-sources-b19f856b-5b9b-48c9-8b93-07484bfab5a7#:~:text=Open%20Database%20Connectivity%20(ODBC)%20is,them%20by%20using%20Microsoft%20Access.)

Then you should be able to use one of the ODBC nodes.

---

<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:** [10 November 2022 12:54 UTC](https://discourse.nodered.org/t/how-to-read-write-in-ms-access-table-by-using-node-red/70380/5 "2022-11-10T12:54:30Z")

</div>

Thanks. Is there also a way to realise this in node-red, for example with the ODBC Query?

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

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [10 November 2022 13:01 UTC](https://discourse.nodered.org/t/how-to-read-write-in-ms-access-table-by-using-node-red/70380/6 "2022-11-10T13:01:39Z")

</div>

ODBC is a driver standard. You have to configure it separately. Once configured on the device, the read/write can be done in node-red.

---

<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 11:24 UTC](https://discourse.nodered.org/t/how-to-read-write-in-ms-access-table-by-using-node-red/70380/7 "2022-11-15T11:24:31Z")

</div>

I connected to the ODBC and can open my table in MS Access

 ![Inked295c5e7e8930e819b1844337dd7445ab70f85240_LI](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/1/f1ec2945769ba581ee8f7946409e265017cdd732.jpeg)

How can i write now some input over node-red to the ODBC table?

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [15 November 2022 18:12 UTC](https://discourse.nodered.org/t/how-to-read-write-in-ms-access-table-by-using-node-red/70380/8 "2022-11-15T18:12:48Z")

</div>

What examples does the odbc node give you?

---

<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:** [17 November 2022 08:01 UTC](https://discourse.nodered.org/t/how-to-read-write-in-ms-access-table-by-using-node-red/70380/9 "2022-11-17T08:01:04Z")

</div>

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

i have this example from a youtube video but it doesnt work for me

espacially because i cant create the right connection

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [17 November 2022 09:27 UTC](https://discourse.nodered.org/t/how-to-read-write-in-ms-access-table-by-using-node-red/70380/10 "2022-11-17T09:27:22Z")

</div>

Bear in mind that I don't use this node and haven't done anything with ODBC in years ... but surely it is a case of changing line 4 `cStoreData` to be the name of your ODBC connection? The rest of the example is just a standard SQL statement.

---

<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:** [16 January 2023 09:27 UTC](https://discourse.nodered.org/t/how-to-read-write-in-ms-access-table-by-using-node-red/70380/11 "2023-01-16T09:27:37Z")

</div>

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