Insert Into Command

I want to Insert data into external db table  from AX

 

how i can write insert into statement in ax batch job ?

i am writing like this but it is not inserting data into external db table

   sqlQuery = strFmt("INSERT INTO tblTrainingForWebSite([ExternalPlanID],[AccountNum],[PHCPHCRegistrationNumber],[FromDate],[ToDate],[trainername] ) VALUES ('%1','%2','%3','%4','%5','%6')",externalPlan.ExternalPlanID,customers.AccountNum,customers.PHCPHCRegistrationNumber,externalPlan.FromDate,externalPlan.ToDate,trainername);
    

Related
Recommended