Import > Delimited text import > Re-Use Target Table

Repeating import from same data source

If you repeatedly import updated data from the same source, as a source to merge with existing data, you may re-use the same target table as illustrated by just double clicking the existing table:

DelimitedTextImport-ReuseTarget

This way the base data is easily supplemented from a steadily updated re-imported datasource as e.g.:

INSERT INTO BaseTable
SELECT DISTINCT Src.*
FROM "Data-Import" Src
LEFT JOIN BaseTable Base
ON Src."TimeStamp" = Base."TimeStamp"
WHERE Base."TimeStamp" IS NULL
;