Import data from text file to sqlite database?


Can you help me with sqlite database? How can I import data from text file into sqlite database?

First you have to determine the structure of the database and how you want to store the data. I.e. build a schema. If you don’t know what that means then the first thing you should do is take an SQLite tutorial

Next you will have to read the text file, you can use the 1st file-in` node for that.

Then you will need to split the record coming in from the file in node - use the splits node for that. Then you have to format the sql to store the data, I’d use a template node for that. And finally insert the data into the database with the `SQLite node.

In the flow tab search for SQLite and you will find the node and a sample flow you can play with.

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