How can I insert data from my_local_table.dbf to my_remote_sql_table using SQLexec ?

Please help me to complete the code below:

thisform.status.Value = "Connecting..."
thisform.status.BackColor = RGB(232,255,232)

WAIT WINDOW TIMEOUT 1

lcServer="siteground150.com"
lcPort= 3306
lcDatabase= "monitorr_acrisoft"
lcUser= "monitorr_******"
lcPassword="**********"
lcStringConn="Driver={MySQL ODBC 5.1 Driver};Server=&lcServer;Port=lcPort;Option=16384;Stmt=;Database=&lcDatabase;Uid=&lcUser;Pwd=&lcPassword"

SQLSETPROP(0,"DispLogin",1)

thisform.status.BackColor = RGB(255,242,236)

lnHandle=SQLSTRINGCONNECT(lcStringConn)
thisform.status.Value = "Connected."
thisform.status.BackColor = RGB(255,232,221)


*****************************************************below I need the code to: ***********************************************

use my_local_table
  
     scan for my_local_table.control = .F. 

* insert   my_local_table.name, my_local_table.address into  my_remote_sql_table.name, address...

* if insert is successful
   replace my_local_table.control with .T.

endscan