Where is my typo?

There is a mistake somewhere. There erro I am getting is syntax error in Insert Statement.


mySql = "INSERT INTO ADD2 ( SVCARRID, ADDR1, ADDR2, ADDR3, ADDR4, ADDR5, " & _
"ImportDate, BillingUnitName ) SELECT SVCARRID, ADDR1, ADDR2, ADDR3, ADDR4, ADDR5 ," & Chr(35) & curdate & Chr(35) & _
", " & Chr(39) & BillingUnitName & Chr(39) & "," & " FROM Temp_ADDRESS;"


thanks in advance

Extra comma right before the FROM statement.