import table from .db file

18 visualizaciones (últimos 30 días)
Toke Søltoft
Toke Søltoft el 23 de Jul. de 2014
Respondida: Toke Søltoft el 23 de Jul. de 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.

Respuesta aceptada

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

Más respuestas (0)

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by