Search on the net for more than three hours but could not find a complete answer, a great god answer ah

CodePudding user response:

Itself is unable to convert
The need to write their own procedures, to use tables and fields related to the management tool to create a sqlite
Read the MDB, Excel or CSV
And then to write a detailed sqlite
In addition, the search for three hours, only is not enough, three days will be able to find the answer

CodePudding user response:

A method is by reading the ACCESS file data, detailed data transmission to the DBGrid,
Step 2,
1, DBGrid1 open ACCESS file specifies the table;
2, DBGrid2 open Sqlite files specified table accordingly;
3, through DBGrid1 data sets of circulation, detailed to DBGrid2 data sets, Append data,
4, save DBGrid2 data set,