外部数据源用sql插入,不过必须插入全部字段才可以(自增列除外)
Dim sql As String = "insert into {表B} s elect [_locked],[_sortkey],第一列,第二列,第三列,第四列,第五列,第六列,第七列,第八列,第九列,第十列 from {表A}"
Dim cmd As New SQLCommand
Dim Count As Integer
cmd.CommandText = sql
Count= cmd.ExecuteNonQuery()
Messagebox.Show( "总共插入" & Count & "行!")