str = "INSERT INTO DataTraffic " & _
"(CurrMonthName,CurrYear,StoreName,Traffic) " & _
"VALUES (" & _
"@CurrMonthName,@CurrYear,@StoreName,@Traffic)"
myCommand = New OleDbCommand(str, myConnection)
myCommand.Parameters.AddWithValue("@CurrMonthName", obj3.CurrMonthName)
myCommand.Parameters.AddWithValue("@CurrYear", obj3.CurrYear)
myCommand.Parameters.AddWithValue("@StoreName", obj3.StoreName)
myCommand.Parameters.AddWithValue("@Traffic", obj3.Traffic)
INSERT INTO Table2 ( FIELD1, FIELD2 )
SELECT Table1.FIELD1, Table1.FIELD2
FROM Table1;
Not sure about you @ symbols ...
mx