Import data from text file to sqlite database?

General
1

Hello,

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

2

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 https://www.tutorialspoint.com/sqlite/index.htm

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.

3

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