Sub 生成新表()
Dim conn As New ADODB.Connection
Set conn = CurrentProject.Connection
Dim RST As New ADODB.Recordset
Dim SQL As String
' Dim cat As New ADOX.Catalog
' Dim cmd As New ADODB.Command
Dim rst1 As New ADODB.Recordset
' cat.ActiveConnection = conn
SQL = "DELETE 产销表W.* FROM 产销表W"
DoCmd.RunSQL SQL
sq = 0
sclj = 0
xslj = 0
qmkc = 0