1,216
社区成员
发帖
与我相关
我的任务
分享
insert into tongji(recno,student_id,question_no,module,score,dificult,distin,getscore,question_type,issend,c_datacode) in 'F:\开发主文件夹\高校考场服务器(移交[2009-7-1])\高校考场服务器\chengjicab\FrontpageAccess__cj.mdb' select i_recno,c_studentid,i_questionno,c_module,s_score,i_difficult,i_distin,s_getscore,i_typeid,l_issend,c_datacode from tbl_account
dim sql as string
dim dbPath as string
dbpath="F:\开发主文件夹\....cj.mdb"
sql="insert into tongji (recno,student_id,...) select i_recno,c_studentid,...from ["& dbpath &"].tbl_account"
or:
sql="insert into tongji (recno,student_id,...) select i_recno,c_studentid,...from tbl_account in ""["& dbpath &"]"