To create a SQLite database from Access

First, we need to use the SQLite Expert Professional tool

1. Create a new database

2, create a database through SQLite expert, and then import--〉data Transfer wizard--〉import data into...--〉ado data Source

3, data source selection provider=microsoft.jet.oledb.4.0; Data Source=e:\xxxxxx.mdb; Persist Security Info=false
Change data source to your own database

4, user name and password to see the need to enter

Simple, rough, fast changeover

To create a SQLite database from Access