conver msaccess SHAPE command to mySQL syntax?

[PinoyDev]

Good day!

I am now currently ugrading our database to mySQL. My problem is that, how to convert the any msaccess SHAPE command to a mySQL database syntax using 6 and get the same result? Below is the sample code:

spath = App.Path & "\employeeaccnt.mdb"
cn.Open "Provider=MSDATASHAPE; Data Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & spath
With cmd
     .ActiveConnection = cn
     .CommandType = adCmdText
     .CommandText = " SHAPE{select * from emppayroll} AS Command1 COMPUTE Command1 by 'TranGrptrno'"
     .Execute
End With

Thank you!