访问/SQL查询

Question

为什么此查询不能在 Access 数据库上运行？它在 MS SQL 数据库上运行得很好。

    Dim MN As Single = 100
    Dim MX As Single = 200

    sql_Data.Reset()
    sql_DA1 = New SqlDataAdapter("select  * into NEWTABLE from OLDTABLE WHERE DEBIT BETWEEN " & "'" & mn & "'" & "AND" & "'" & mx & "'", sql_con)
    sql_DGV1 = New SqlCommandBuilder(sql_DA1)
    sql_DA1.Fill(sql_Data)

谢谢。

Answer 1

Debit 是数字，因此：

"select * into NEWTABLE from OLDTABLE where DEBIT between " & mn & " and " & mx & ""