Dim sql As String sql = sql & "CREATE TABLE #TempTbl ("
sql = sql & " [PrgmID] Long NOT NULL,"
sql = sql & " [PrgmName] char(255) NOT NULL,"
sql = sql & " [PrgmTagFileName] char(255) NOT NULL,"
sql = sql & " [Channel] char(255) NOT NULL)"
Set connTemp = New ADODB.Connection
'connTemp.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strProgramDB + ";Jet OLEDB:Engine Type=4;"
connTemp.Execute sql '这里出错
rsTemp.Open "select * from #TempTbl", connTemp为什么说SQL语句出错了?
sql = sql & " [PrgmID] Long NOT NULL,"
sql = sql & " [PrgmName] char(255) NOT NULL,"
sql = sql & " [PrgmTagFileName] char(255) NOT NULL,"
sql = sql & " [Channel] char(255) NOT NULL)"
Set connTemp = New ADODB.Connection
'connTemp.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strProgramDB + ";Jet OLEDB:Engine Type=4;"
connTemp.Execute sql '这里出错
rsTemp.Open "select * from #TempTbl", connTemp为什么说SQL语句出错了?
产生的表还要进行Group等操作。
mysql 可以这样的
create temporary table newtable select a,b,c from oldtable
以#为前缀的临时表是SQLServer的标准,access不支持,只会当作普通的表来对待