import table from .db file

I have some sqlite .db files which I want to import into matlab. The .db file is attached.

How can I import a selected table from the .db(I need the DPV table) or even the whole .db into matlab, into a structure or something. The .db files will never have a huge size.

I have look around for connecting to a sql database, but I can only find solution for connecting remotely to one. I have these .db files locally.

There must be a simple solution to this that I can't see.

Answer 1

[Toke Søltoft]

The easiest way (I think) is to use sqlite3:

system('sqlite3 -header -csv project.db "select * from DPV;" > results.csv');