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

**URL:** <https://discourse.nodered.org/t/how-to-read-write-from-ms-access-by-using-node-red/42239>\
**Category:** General\
**Tags:** database\
**Created:** [8 March 2021 05:39 UTC](https://discourse.nodered.org/t/how-to-read-write-from-ms-access-by-using-node-red/42239 "2021-03-08T05:39:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![supravat](https://avatars.discourse-cdn.com/v4/letter/s/47e85d/32.png) [@supravat](https://discourse.nodered.org/u/supravat)\
**Post date:** [8 March 2021 05:39 UTC](https://discourse.nodered.org/t/how-to-read-write-from-ms-access-by-using-node-red/42239/1 "2021-03-08T05:39:46Z")

</div>

Hi, Greeting to everyone.

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

But i am not getting any node related to MS Access

Please guide me how to achieve this.

---

<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:** [8 March 2021 22:23 UTC](https://discourse.nodered.org/t/how-to-read-write-from-ms-access-by-using-node-red/42239/2 "2021-03-08T22:23:28Z")

</div>

The normal methods to get data to/from an MSFT Access database are ADODB and ODBC. I can't find any nodes for the former but there are several for ODBC:

[Library - Node-RED](https://flows.nodered.org/search?term=odbc)

You will need a suitable ODBC driver for whatever OS you are running on.

---

<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:** [7 May 2021 22:24 UTC](https://discourse.nodered.org/t/how-to-read-write-from-ms-access-by-using-node-red/42239/3 "2021-05-07T22:24:13Z")

</div>

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