急!!!!打开客户机文件的问题?
我要在客户机上打开*.xls,通过<input type="file" name="LianJie" size="65" maxlength=100 >传来地址,如:LianJie="D:\whb\date\Book2.xls";
然后,用:
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Excel Driver (*.xls)};ReadOnly=0;DBQ=" & LianJie
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Select * From [sheet1$]",conn,3,3
打开,但是,结果是,他跑去服务器上找D:\whb\date\Book2.xls文件,不是寻找本机的文件,结果出错。但是,如果在服务器上建D:\whb\date\Book2.xls,结果显示正常,谁能帮我????