WinCE Application: using database SQLLite and import data from EXCEL

最新推荐文章于 2024-09-20 19:22:55 发布

xiaxia347

最新推荐文章于 2024-09-20 19:22:55 发布

阅读量609

点赞数

分类专栏： Embbed WinCE@ARM 文章标签： wince database import application excel library

本文链接：https://blog.csdn.net/xiaxia347/article/details/7398070

版权

Embbed WinCE@ARM 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

1 requirement:

There is requirement to operate about 20000+ unit of data in a WinCE program, and the data comes from PC as excel, actually data comes from the automation design tools and experiments, such as Matlab. The data need to be changed easily, so it can't be hard coded, then I think an embbed data base would be perfect for this situation.

2 Mapping the data:

graph1. import the data to embbed database

As the graph shows, A UI program on PC is needed to let automation engineer select and convert his data into database. The program using ODBC(an excel driver on windows) to access XML file, and using SQLLite library to saving data into database format.

3 installing sqllite in WinCE

I did not found a UI in WinCE for SQLLite, but there is a library available so the main program could use the API and link it.