Hi ,
i am trying data insert from one table to new table .
function save_throw()
' Define sql statement for dynamic update
sql = "insert into Comp (Load Sales_Call_Date,'1',SALES_CALL_ID,'0' RESIDENT Sales_Call_TRN )"
' Run dynamic update
set test1=ActiveDocument.DynamicUpdateCommand(sql)
if test1=false then
Msgbox test1.ErrorMessage
end if
end function
at time pop up this error
',' or ')' expected in INSERT statement;
Thanks for Advance help
Regards ,
Perumal.A