import table from .db file

18 次查看（过去 30 天）
Toke Søltoft
Toke Søltoft 2014-7-23
回答： Toke Søltoft 2014-7-23
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.

请先登录，再回答此问题。

采纳的回答

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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by