字符串的语法错误 在查询表达式

  sql = "INSERT INTO users(name1,name2,namez,rank,address,tel,post,country,email,area,paynum) VALUES('" sql = sql + trim(replace(name1,"'","’")) + "','" sql = sql + trim(replace(name2,"'","’")) + "','" sql = sql + trim(replace(namez,"'","’")) + "','" sql = sql + trim(replace(rank,"'","’")) + "','" sql = sql + trim(replace(address,"'","’")) + "','" sql = sql + trim(replace(tel,"'","’")) + "','" sql = sql + trim(replace(post,"'","’")) + "','" sql = sql + trim(replace(country,"'","’")) + "','" sql = sql + trim(replace(email,"'","’")) + "'," sql = sql + trim(replace(paynum,"'","’")) + "'," sql = sql + cstr(area) + ")" 'response。
  write sql conn。execute sqlpaynum这个是后加的，，在本身的程序上修改，，运行就出错了，，，，Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'[Microsoft][ODBC Microsoft Access Driver] 字符串的语法错误 在查询表达式 ' ',1)' 中。
  /up/mo_ p，行 104。