Simple DB process method in program

Used to process simple DB in Windows by using Python, C++ and C# before, the DB was Microsoft Access and SQLite. 1, Python to import DB to Microsoft Access, code as below, for illustration only, conn = win32com.client.Dispatch(“ADODB.Connection”) DSN=”Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” + db conn.Open(DSN) insertfmt = “SQL command here” sql = insertfmt.format(“prepare the data here”) conn.Execute(sql) […]