Using SQLite instead of Excel

[Andrew_Hannell]

is your friend- please use it…

There are examples on this forum (some by me) on how to write to an SQLite database
The short answer is that you use either an INSERT or an UPDATE query, depending if they are new records, or updating existing ones

Refer:

Revit Dynamo access Database

Hi @jorgen.fidjeland I have played around with this. It seems pretty easy to use SQLite with PowerBI, or MSAccess (as well as Dynamo) The SQLite database can easily replace the tables in MSAccess and then this data used as a linked table in Access. Similar approach for PowerBI or any other application (Excel etc etc) Correction to the above- SQLite can contain views (aka queries) In the below example, I write (room data) out to an external database using Dynamo- then use this data in PowerB…