OPENROWSET导出excel时出错 [英] Error in OPENROWSET Export excel

问题描述

insert into OPENROWSET( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\Tracking.xls;;HDR=YES', 'SELECT * FROM [Sheet1$]') select * from TDR

我正在使用此查询导出。



但收到错误消息

am using this query to export .

But getting error message

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "The Microsoft Jet database engine could not find the object 'Sheet1$'.  Make sure the object exists and that you spell its name and the path name correctly.".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

推荐答案

'）选择 * 来自 TDR

我正在使用此查询导出。



但是收到错误消息

am using this query to export .

But getting error message

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "The Microsoft Jet database engine could not find the object 'Sheet1

'。确保对象存在，并正确拼写其名称和路径名。。
Msg 7350 ，等级 16 ，状态 2 ，行 1
无法获取来自 OLE DB提供程序 Microsoft.Jet.OLEDB.4.0 链接服务器 （null）。

'. Make sure the object exists and that you spell its name and the path name correctly.". Msg 7350, Level 16, State 2, Line 1 Cannot get the column information from OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

可能是您已打开的Excel Excel表格或Excel表格的路径不正确...



查看链接.. 。



SQL Server 2008 - 导入导出向导 [ ^ ]

导出到Excel [ ^ ]

SQL SERVER - 2005 - 将数据从SQL Server 2005导出到Microsoft Excel数据表 [ ^ ]



问候，

GVPrabu

Hi,

May be your Source Excel Sheet already Opened or Path of the Excel Sheet is not correct...

Check the links...

SQL Server 2008 - Import-Export Wizard [^]
Export to Excel[^]
SQL SERVER – 2005 – Export Data From SQL Server 2005 to Microsoft Excel Datasheet[^]

Regards,
GVPrabu

这篇关于OPENROWSET导出excel时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！