Dim rsTemp As Recordset
Dim dbTemp As Database
Dim astr As String
Set dbTemp = DBEngine(0).OpenDatabase("e:\ga1\db1.mdb")
SQL = "select distinct number,name from 表1"
Set rsTemp = dbTemp.OpenRecordset(SQL)
astr = "delete from 表1"
dbTemp.Execute astr
??? astr = "insert into [表1] ([number],[name]) select * from rstemp"
dbTemp.Execute astr
请问带 ???标记的句子应该怎么写?
Dim dbTemp As Database
Dim astr As String
Set dbTemp = DBEngine(0).OpenDatabase("e:\ga1\db1.mdb")
SQL = "select distinct number,name from 表1"
Set rsTemp = dbTemp.OpenRecordset(SQL)
astr = "delete from 表1"
dbTemp.Execute astr
??? astr = "insert into [表1] ([number],[name]) select * from rstemp"
dbTemp.Execute astr
请问带 ???标记的句子应该怎么写?
astr = "delete from 表1"
dbTemp.Execute astr
astr = "insert into [表1] ([number],[name]) values (" & rsTemp.fields("number") & ", '" & rsTemp.fields("name") & "') "
Dim dbTemp As Database
Dim astr As String
Set dbTemp = DBEngine(0).OpenDatabase("e:\ga1\db1.mdb")
SQL = "select distinct number,name from 表1"
Set rsTemp = dbTemp.OpenRecordset(SQL)
astr = "delete from 表1"
dbTemp.Execute astr
while not rsTemp.eof
astr = "insert into [表1] ([number],[name]) values (" & rsTemp.fields("number") & ", '" & rsTemp.fields("name") & "') "
dbTemp.Execute astr
rsTemp.movenext
wend
Dim dbTemp As Database
Dim astr As String
Set dbTemp = DBEngine(0).OpenDatabase("e:\ga1\db1.mdb")
SQL = "select distinct number,name from 表1"
Set rsTemp = dbTemp.OpenRecordset(SQL)
astr = "delete from 表1"
dbTemp.Execute astr
while not rsTemp.eof
astr = "insert into [表1] ([number],[name]) values (" & rsTemp.fields("number") & ", '" & rsTemp.fields("name") & "') "
dbTemp.Execute astr
rsTemp.movenext
wend
Dim dbTemp As Database
Dim astr As String
Set dbTemp = DBEngine(0).OpenDatabase("e:\ga1\db1.mdb")
SQL = "select distinct number,name from 表1"
Set rsTemp = dbTemp.OpenRecordset(SQL)
astr = "delete from 表1"
dbTemp.Execute astr
while not rsTemp.eof
astr = "insert into [表1] ([number],[name]) values (" & rsTemp.fields("number") & ", '" & rsTemp.fields("name") & "') " dbTemp.Execute astr
rsTemp.movenext
wend