VB Forum / Database Access / October 2006

Is there any significant reson why I should use one of these verions of code
over the other. Both are using JET 4.0 databases.

------------original code---------------------------------------
       sql = "DELETE * FROM QCOILS"
       Set cmd = New ADODB.Command
       cmd.CommandText = sql
       cmd.CommandType = adCmdText
       cmd.ActiveConnection = cnnWork1
       cmd.Execute
       sql = "INSERT INTO QCOILS SELECT * FROM " & MyCcid
       cmd.CommandText = sql
       cmd.CommandType = adCmdText
       cmd.ActiveConnection = cnnWork1
       cmd.Execute
       Set cmd = Nothing

-----------------modified code------------------------------------------------
           sql = "DROP TABLE QCOILS"
           With cmd
               .CommandType = adCmdText
               .CommandText = sql
               .ActiveConnection = cnnWork1
               .Execute
           End With
    sql = "SELECT * INTO QCOILS FROM " & MyCcid  
   Set cmd = New ADODB.Command
   With cmd
       .ActiveConnection = cnnWork1
       .CommandType = adCmdText
       .CommandText = sql
       .Execute
   End With
   Set cmd = Nothing