//和版本:
选择\ *
来自 OpenDataSource(\\" Microsoft.ACE.OLEDB.12.0",
" Data =源":c:\\ book1.xlsx \";用户\\ ; ID = Admin;密码=;扩展属性= Excel 12.0")...[Sheet1 $]
SELECT * \\ n来自 OPENROWSET(" Microsoft.ACE.OLEDB.12.0"," Excel \\ 12.0;数据库= C:\\\\ book1.xlsx"," SELECT * FROM \ nbsp ; [Sheet1 $ A1:D100]")
SELECT * \\ n来自 OPENROWSET(" Microsoft.ACE.OLEDB.12.0"," Excel \\ 12.0;数据库= C:\\\\ book1.xlsx",\\\\\ \\ * *从\ nbsp ; [Sheet1 $]")
//版本:
SELECT *
来自\ OpenDataSource(\\" Microsoft.Jet.OLEDB.4.0",
"数据\\"源= \ quot; c:\\\\ book1.xls \ quot ;;用户\ nbsp ID =管理员;密码=;扩展属性= Excel 8.0")...[Sheet1 $]
SELECT * \\ n来自 OPENROWSET(" Microsoft.Jet.OLEDB.4.0"," Excel \\ 8.0";数据库= C:\\\\ book1.xls"," \";" SELECT \\\" * * \ nbsp; FRO M [Sheet1 $]")
SELECT \ * \\ n来自 OPENROWSET(" Microsoft.Jet.OLEDB.4.0"," Excel 8.0;数据库= C:\\\\ book1.xls","选择 * FROM \ nbsp ; [Sheet1 $ A1:D100]")
//而且,您还需要e79fa5e98193e59b9ee7ad9431333335313831使用具有服务器sysadmin角色权限的登录帐户,首先执行以下语句以打开SQL。 " Ad hoc Hoc"(分布式)"查询"开关。
exec \\\ sp_configure \\ n00; "显示高级选项",1;重新配置;
exec \\\ sp_configure \\ n00; " Ad Hoc","分布式查询",1;重新配置;
//执行查询后,以相反的顺序使用语句以关闭" Ad Hoc \\ Distributed \\ Queries"开关。
exec \\\ sp_configure \\ n00; " Ad Hoc"(分布式)"查询",0;
重新配置; exec \ sp_configure \\"显示"高级选项。