Does someone here have experience with importing data from a CSV file into SQLite with node-red-node-sqlite ?
I tried so far:
COPY syslog FROM 'E:\Path\to\syslog.csv' DELIMITER ',' CSV HEADER;
IMPORT 'E:\Path\to\syslog.csv' syslog
Both COPY and IMPORT throw a syntax error.
Importing the CSV file with the SQLite Browser works without any issues.