Sql="insert into OpenDataSource (Microsoft) Jet. The OLEDB. 4.0, Data Source=" & amp; App. The Path & amp; "\ JCSJK MDB, Persist Security Info=False) GXMCB (GXDM GXMC, neibie, luruyuan, beizhu)"
Sql=Sql & amp; "Select GXDM GXMC, neibie luruyuan, beizhu from ZGXMCB"

The SQL statement pass, please the teacher help modify, thanks

CodePudding user response:

Do you want to implement the data table from another data field is inserted into another table like this?
Insert into newtable (fld1 fid2) select A, B from the table