主题:合并数据表问题
代码如下:
Dim connStr, selectCmd As String, i As Integer
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\TelData\TelData.mdb;Persist Security Info=False"
selectCmd = "select Person.*,Temp.* from Person,Temp into Person"
Dim conn As System.Data.OleDb.OleDbConnection, myAdapter As System.Data.OleDb.OleDbDataAdapter
conn = New System.Data.OleDb.OleDbConnection(connStr)
conn.Open()
Dim myDataSet As DataSet = New DataSet
myAdapter = New System.Data.OleDb.OleDbDataAdapter(selectCmd, conn)
myAdapter.Fill(myDataSet, "Person")
conn.Close()
为什么运行到"myAdapter = New System.Data.OleDb.OleDbDataAdapter(selectCmd, conn)"出现"From 子句语法错误"???
怎么改??
不敬感谢
Dim connStr, selectCmd As String, i As Integer
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\TelData\TelData.mdb;Persist Security Info=False"
selectCmd = "select Person.*,Temp.* from Person,Temp into Person"
Dim conn As System.Data.OleDb.OleDbConnection, myAdapter As System.Data.OleDb.OleDbDataAdapter
conn = New System.Data.OleDb.OleDbConnection(connStr)
conn.Open()
Dim myDataSet As DataSet = New DataSet
myAdapter = New System.Data.OleDb.OleDbDataAdapter(selectCmd, conn)
myAdapter.Fill(myDataSet, "Person")
conn.Close()
为什么运行到"myAdapter = New System.Data.OleDb.OleDbDataAdapter(selectCmd, conn)"出现"From 子句语法错误"???
怎么改??
不敬感谢