Access to sqlite using DBManagerprofessional Software

The following method has a problem: Ghost needs to develop a sqlite-based android software. Because the data used is stored in access, you need

The following method has a problem: After conversion is sqlite. db file is ANIS neural type, not suitable for Qt programming, can not realize the Chinese recognition http://www.cnblogs.com/AlexCheng/archive/2011/07/26/2119982.html latest need to develop a sqlite-based android software. Because the data used is stored in access, you need

The following method has a problem:

After conversion, the sqlite. db file is in the ANIS encoding format. It is not suitable for Qt programming and cannot recognize Chinese characters.

Http://www.cnblogs.com/AlexCheng/archive/2011/07/26/2119982.html

We need to develop a sqlite-based android software. Because the data used is stored in access, you need to convert access to xml or sqlite. In the xml conversion process, due to a large amount of data, the transfer encountered insufficient memory. Simply convert access to sqlite.

The method is as follows:

1. Download The Conversion Tool http://www.dbtools.com.br/en/downloads/download the Professional Edition. Although it is charged, there is a 20-day trial. Database conversion is not often used, so it has little impact. You can install it as needed.

You can choose to install this step. You can also install them all.

Installation complete. Open

2. Create an sqlite database.

In the left-side tree list, right-click the sqlite3 @ databases (SQlite) or sqlite2 @ databases (SQLite) of SQLite, select create database, and enter the database Name and save path. Complete

3. Import Access, select sqlite_data, and choose tools> Data Management> Import Data (DAO) to Import the access database.

Select the table to be imported and the type to be imported. Select All

At this time, the import progress bar will appear in the lower right corner. The following dialog box is displayed, indicating the number of imported tables and indexes.

In this case, expand the tree menu on the left to indicate that the import is successful.

Find the saved sqlite file and click Properties. You will find that sqlite is 1/4 less than the original access file. Now we can use sqlite for android programs.