EXCEL 批量生成SQL

1、批量生成更新语句

　　="update applyloan_zx set fangkuanmoney="&A2&",fangkuantime='"&B2&"',LendingWay='"&C2&"',LendingID="&D2&" where applycode='"&E2&"'"