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

General
1

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.

2

Are you wanting to do this on Windows or Linux?

3

Windows if this is possible

4

Yes, that is fairly straight-forwards.

This page tells you how to set up the ODBC driver: Administer ODBC data sources (microsoft.com)

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

5

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

image

6

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.

7

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

Inked295c5e7e8930e819b1844337dd7445ab70f85240_LI
Inked295c5e7e8930e819b1844337dd7445ab70f85240_LI944×88 23 KB

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

8

What examples does the odbc node give you?

9

image
image1071×532 90.6 KB

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

espacially because i cant create the right connection

10

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.