import table from .db file

22 views (last 30 days)
Toke Søltoft
Toke Søltoft on 23 Jul 2014
Answered: Toke Søltoft on 23 Jul 2014
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.

Accepted Answer

Toke Søltoft
Toke Søltoft on 23 Jul 2014
The easiest way (I think) is to use sqlite3:
system('sqlite3 -header -csv project.db "select * from DPV;" > results.csv');

More Answers (0)

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!