Where is my typo?

swoozie
01-08-2004, 01:19 PM
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

00100b
01-08-2004, 01:28 PM
Extra comma right before the FROM statement.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum