哪里错了!
jnzsk 2004-12-23 09:38:03 insert OPENDATASOURCE('SQLOLEDB','Data Source="&request.ServerVariables("SERVER_NAME")& ";User ID=sa;Password=').gbcp.dbo.cjtp (pxh,xm,xb,csny,zw,zwjb,ejid,sjid,sfzh,gzsj,zzmm,rdsj,jszw,yxl,xxl) SELECT pxh,xm,xb,csny,zw,zwjb,ejid,sjid,sfzh,gzsj,zzmm,rdsj,jszw,yxl,xxl FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source=" &filepath& ";User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$
错误信息
------------------------------------------------------------
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB 提供程序 'Microsoft.Jet.OLEDB.4.0' 不包含表 'Sheet1$'。该表可能不存在,或当前用户没有使用该表的权限。