如何使用openrowset打开xlsx文件? [英] How to use openrowset to open xlsx file ?
问题描述
我将在步骤中充分解释我的演示,以便服务器计算机将命名为A并且远程计算机将命名为B
1-I安装SQL 2012 ON'A'并且完全配置它允许并从服务器计算机执行此查询='A'和&我很有成就
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.15.0','Excel12.0; Database = C:\ Users \Administrator \Desktop\test.xlsx; HDR = YES; IMEX = 1','SELECT * FROM [Sheet1 $]')
2-来自远程计算机='B'我安装了SQL2012,我配置它允许OPENROWSET QUERY;现在当我在远程计算机上时,我遇到了这个问题='B'并且我很快就连接到了远程服务器并运行了同样的问题它给了我以下错误
消息7302,等级16,状态1,第1行
无法为链接服务器创建OLE DB提供程序Microsoft.ACE.OLEDB.15.0的实例
3 - 当我在远程COPUTER ='B'并且我在远程计算机的SQL服务器的本地帐户下运行相同的QURY我也很快就开始运行但是如果我远程连接到计算机A的服务器而我就是我IT失败。
**我使用WINDOWS7 LITE X32
**我安装OFFICE2013 ON BOOTH
**我有权阅读和阅读TEMP文件夹
**我启用了分发的查询和AllowInProcess和DynamicParameters
CAN U PLZ帮助我
我的尝试:
**我使用的是WINDOWS7 LITE X32 >
**我INSTAL LED OFFICE2013 ON BOOTH
**我有权写作并阅读TEMP文件夹
**我启用了分布式查询和AllowInProcess AND DynamicParameters
I WILL ILUSSTERATE MY PROPLEM IN STEPS TO BE FULLY EXPLAINED BEARING IN MIND THAT THE SERVER COMPUTER WILL TAKE NAME 'A' AND THE REMOTE COMPUTER WILL TAKE THE NAME 'B'
1-I INSTALLED SQL 2012 ON 'A' AND FULLY CONFIGURED IT TO PERMIT AND PERFORM THIS QUERY FROM THE SERVER COMPUTER='A' & I RAN IT SUCCEFULY
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.15.0','Excel12.0;Database=C:\Users\Administrator\Desktop\test.xlsx;HDR=YES;IMEX=1', 'SELECT * FROM [Sheet1$]')
2- FROM A REMOTE COMPUTER='B' I INSTALLED SQL2012 ALSO AND I CONFIGURED IT TO ALLOW OPENROWSET QUERY; NOW THE PROMBLEM COMES WHEN I BE ON THE REMOTE COMPUTER='B' AND I CONNECT SUCCSSEFULY TO THE REMOTE SERVER AND RUN THE SAME QUERY IT GIVES ME THE FOLLOWING ERROR
"Msg 7302, Level 16, State 1, Line 1
Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.15.0" for linked server "
3- WHEN I BE ON THE REMOTE COPUTER='B' AND I RUN THE SAME QURY UNDER THE LOCAL ACCOUNT OF SQL SERVER OF THE REMOTE COMPUTER I ALSO RUN IT SUCCSSEFULLY BUT AGAIN IF I RECONNECT REMOTLY TO THE SERVER OF COMPUTER A AND I RAN I IT FAILS.
** I AM USING WINDOWS7 LITE X32
** I INSTALLED OFFICE2013 ON BOOTH
** I HAVE THE PERMISSIONS TO WRITE AND READ ON THE TEMP FOLDER
** I ENABLED DISTRIBUTED QUERIES AND AllowInProcess AND DynamicParameters
CAN U PLZ HELP ME
What I have tried:
** I AM USING WINDOWS7 LITE X32
** I INSTALLED OFFICE2013 ON BOOTH
** I HAVE THE PERMISSIONS TO WRITE AND READ ON THE TEMP FOLDER
** I ENABLED DISTRIBUTED QUERIES AND AllowInProcess AND DynamicParameters
推荐答案
')
2-来自远程计算机='B'我安装了SQL2012,我配置它允许OPENROWSET查询;现在当我在远程计算机上时,我遇到了这个问题='B'并且我很快就连接到了远程服务器并运行了同样的问题它给了我以下错误
消息7302,等级16,状态1,第1行
无法为链接服务器创建OLE DB提供程序Microsoft.ACE.OLEDB.15.0的实例
3 - 当我在远程COPUTER ='B'并且我在远程计算机的SQL服务器的本地帐户下运行相同的QURY我也很快就开始运行但是如果我远程连接到计算机A的服务器而我就是我IT失败。
**我使用WINDOWS7 LITE X32
**我安装OFFICE2013 ON BOOTH
**我有权阅读和阅读TEMP文件夹
**我启用了分发的查询和AllowInProcess和DynamicParameters
CAN U PLZ帮助我
我的尝试:
**我使用的是WINDOWS7 LITE X32 >
**我INSTAL LED OFFICE2013 ON BOOTH
**我有权写作并阅读TEMP文件夹
**我启用了分布式查询和AllowInProcess AND DynamicParameters
')
2- FROM A REMOTE COMPUTER='B' I INSTALLED SQL2012 ALSO AND I CONFIGURED IT TO ALLOW OPENROWSET QUERY; NOW THE PROMBLEM COMES WHEN I BE ON THE REMOTE COMPUTER='B' AND I CONNECT SUCCSSEFULY TO THE REMOTE SERVER AND RUN THE SAME QUERY IT GIVES ME THE FOLLOWING ERROR
"Msg 7302, Level 16, State 1, Line 1
Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.15.0" for linked server "
3- WHEN I BE ON THE REMOTE COPUTER='B' AND I RUN THE SAME QURY UNDER THE LOCAL ACCOUNT OF SQL SERVER OF THE REMOTE COMPUTER I ALSO RUN IT SUCCSSEFULLY BUT AGAIN IF I RECONNECT REMOTLY TO THE SERVER OF COMPUTER A AND I RAN I IT FAILS.
** I AM USING WINDOWS7 LITE X32
** I INSTALLED OFFICE2013 ON BOOTH
** I HAVE THE PERMISSIONS TO WRITE AND READ ON THE TEMP FOLDER
** I ENABLED DISTRIBUTED QUERIES AND AllowInProcess AND DynamicParameters
CAN U PLZ HELP ME
What I have tried:
** I AM USING WINDOWS7 LITE X32
** I INSTALLED OFFICE2013 ON BOOTH
** I HAVE THE PERMISSIONS TO WRITE AND READ ON THE TEMP FOLDER
** I ENABLED DISTRIBUTED QUERIES AND AllowInProcess AND DynamicParameters
阅读: OLE DB提供程序& quot; Microsoft.ACE.OLEDB.12.0& ; QUOT;对于链接服务器& quot;(null)& quot;报告错误。访问被拒绝。 [ ^ ]
按照MSDN文档中提供的步骤操作:尝试时出现错误消息在SQL Server中创建OLE DB提供程序的实例:无法创建OLE DB提供程序的实例 [ ^ ]
Follow the steps provided in MSDN documentation: Error message when you try to create an instance of an OLE DB provider in SQL Server: "Cannot create an instance of OLE DB provider"[^]
这篇关于如何使用openrowset打开xlsx文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!