用asp编程 现在得到一个字串,
像这样一个
9502840 9064113 9455999 1395516 1316744 1315748 1323045 1916262 1408725 1329193 1320552 1320286 1320096 390 1320578 9502955 9502783 9502735 9502672 9513196 8976183 8716583 8716554 8976080 8926131 8716662 8976249 8976428 8976346 8976306 1320415 1316702 1321610 1316655 1316837 42344 42258 1315939 1395624 1395742 8668559 1408963 1395701 1316041 227760 8668488 6731767 7013732 7014096 7013529
如何用split把它分割成一个个数字
9502840
9064113
像这样，并且把它们写入数据库，且每个数字为一个记录
split("9502840 9064113 9455999 1395516 1316744 1315748 1323045 1916262 1408725 1329193 1320552 1320286 1320096 390 1320578 9502955 9502783 9502735 9502672 9513196 8976183 8716583 8716554 8976080 8926131 8716662 8976249 8976428 8976346 8976306 1320415 1316702 1321610 1316655 1316837 42344 42258 1315939 1395624 1395742 8668559 1408963 1395701 1316041 227760 8668488 6731767 7013732 7014096 7013529"," ")
a = splite("9502840 9064113 9455999 "," ")
for i=0 to 获取数组长度函数 一时不记得!
sql = "insert into table Column values('"&a[i]&"')"
conn.execute(sql)
next