iNSERT CSV DATA IN MS ACCESS

#1

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

0 Likes

#2

You can search the majority of nodes on flows.nodered.org

0 Likes

#3

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 :slight_smile:

0 Likes