回 帖 发 新 帖 刷新版面

主题:合并数据表问题

代码如下:
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 子句语法错误"???
怎么改??
不敬感谢

回复列表 (共1个回复)

沙发

当然就是from Person,Temp into Person出问题了
你看看这样写对吗?

我来回复

您尚未登录,请登录后再回复。点此登录或注册