update语句里面能不能有jion啊???大家看看这语句错在哪里....
update HW_COURSE set COURSE_REMARK=a.COURSE_REMARK from HW_COURSE a jion OpenDataSource"+
"( 'Microsoft.Jet.OLEDB.4.0','Data Source="+str+";User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$ as a "+
"where a.COURSE_ID=HW_COURSE.COURSE_ID
问题点数：20、回复次数：1Top
1 楼singlepine（小山）回复于 2005-11-03 20:36:27 得分 0
试试这个
update HW_COURSE set COURSE_REMARK=b.COURSE_REMARK from HW_COURSE b,OpenDataSource"+"( 'Microsoft.Jet.OLEDB.4.0','Data Source="+str+";User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$ as a "+
"where a.COURSE_ID=b.COURSE_ID
Top
