Sql = "insert into OpenDataSource( Microsoft.Jet.OLEDB.4.0,Data Source=" & App.Path & "\jcsjk.mdb,Persist Security Info=False ) gxmcb (gxdm,gxmc,neibie,luruyuan,beizhu) "
Sql = Sql & " select gxdm,gxmc,neibie,luruyuan,beizhu from zgxmcb"
這SQL陳述句通不過,請老師幫忙修改下,謝謝
uj5u.com熱心網友回復:
你是要實作從另外一個資料表里的資料欄位插入到另外一個表里這樣嘛?insert into newtable(fld1,fid2) select A,B from table
轉載請註明出處,本文鏈接:https://www.uj5u.com/gongcheng/115389.html
標籤:控件
