Easily Append Rows to a Table from Multiple CSV files using DB Browser for SQLite

Here is a cool trick I found while working with DB Browser. I had multiple CSVs that all needed to into 1 table. This is possible and the steps to do it aren’t explicit. Here’s what you’ll need to do:

When uploading subsequent CSV files, make sure you to use the exact table name that already exists in your database

After hitting OK, you be prompted to import the data to the existing table. This operation appends the data to the table. (ie it does NOT replace the data that’s already there). Select Yes to All


Posted

in

by

Tags: