sql - 将数据从 SQL Server 表导出到现有 EXCEL 文件

Question

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

此代码不起作用..它给出了错误

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 2
Cannot get the column information from OLE DB provider "Microsoft.Jet.OLEDB.4.0" 
for linked server "(null)".

请帮忙

Answer 1

原来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 .