CODEWITHSUNDEEP
sqlsqlite
Cake Princess
Cake Princess

Reputation: 217

Newbie: What is the easiest way to bulk add data to a sqlite database?

I'm a total newbie to SQL, and I'd like to know whether anyone knows a means for easily "copy and pasting" hundreds of entries to a sqlite database. Again, I'm not a professional programmer, so software that could automate that process would be great. (I primarily code in JavaScript, but SQL code can be used as well if you could kindly explain the code.)

Essentially, the text I'd be adding would be delimited by a character (the '|' character in my case) for the columns, and line breaks for the rows. It would be added onto a table that's already being used in the database, with columns already set up.

Thanks a lot!! Any suggestions are most appreciated!

Upvotes: 0

Views: 667

Answers (1)

Thaer A
Thaer A

Reputation: 2323

You can use DB Browser for SQLite and then File > Import > From CSV file.. after creating a New Database.

Upvotes: 1

Related Questions