vba oledb连接mysql_VBA基础四：数据库链接(WPS2019)

Provider=Microsoft.Jet.OLEDB.4.0;

User ID=Admin;

Data Source=G:\20200627\test.mdb;

Mode=Share Deny Write;

Extended Properties="";

Jet OLEDB:System database="";

Jet OLEDB:Registry Path="";

Jet OLEDB:Database Password="";

Jet OLEDB:Engine Type=5;

Jet OLEDB:Database Locking Mode=0;

Jet OLEDB:

Global Partial Bulk Ops=2;

Jet OLEDB:Global Bulk Transactions=1;

Jet OLEDB:New Database Password="";

Jet OLEDB:Create System Database=False;

Jet OLEDB:Encrypt Database=False;

Jet OLEDB:Don‘t Copy Locale on Compact=False;

Jet OLEDB:Compact Without Replica Repair=False;

Jet OLEDB:SFP=False

Sub 把Excel数据插入数据库中()

‘*******************************************

‘时间：2013-01