Convert access to SQLite

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 AndroidProgram.