导入excel到sql表 [英] import excel to sql table

问题描述

- 场景 -



i已将我的excelsheet保存在桌面上并关闭



--in sql server

--Scenario--

i have saved my excelsheet in my desktop and its closed

--in sql server

SP_CONFIGURE  'AD HOC DISTRIBUTED QUERIES' ,1
GO
RECONFIGURE
go

insert into temp_adhoc_arihant
(
userid,
starttime,
endtime
)
select * from 
openrowset ('MICROSOFT.JET.OLEDB.4.0','EXCEL 8.0; DATABASE=C:\Users\anurag.nayak\Desktop\sirumanual.xls','SElECT * FROM [DATA$]') 
GO

--But i am getting error
Cannot create an instance of OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)".

I have restarted sql server. But same error.

--How to fix it ?

推荐答案

'）
GO

- 但我收到错误
无法创建实例 OLE DB提供程序 链接服务器 （空）。

我已经重新启动了sql server。但同样的错误。

- 如何解决？

') GO --But i am getting error Cannot create an instance of OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)". I have restarted sql server. But same error. --How to fix it ?

检查系统上安装的OLEDB驱动程序版本并使用版本号..

检查：

http://cleancode4devs.blogspot.in/2012/01/import-data-from- excel-to-sqlserver.html [ ^ ]

http://snipplr.com/view/ 38349 / [ ^ ]

http：//www.excel-sql-server .com / excel-import-to-sql-server-using-distributed-queries.htm [ ^ ]

http://www.maxxxie.net/2012/07/01/the-joys -of-imports-excel-data-into-sql-2008-r2 / [ ^ ]

HTTP：// geeks.ms/blogs/lmblanco/archive/2012/05/11/generate-sql-server-test-data-from-excel-the-transfer-to-sql-server-and-2.aspx [ ^ ]

Check the OLEDB Drivers Version Installed on your System and Use the Version Number..
Check this:
http://cleancode4devs.blogspot.in/2012/01/import-data-from-excel-to-sqlserver.html[^]
http://snipplr.com/view/38349/[^]
http://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm[^]
http://www.maxxxie.net/2012/07/01/the-joys-of-importing-excel-data-into-sql-2008-r2/[^]
http://geeks.ms/blogs/lmblanco/archive/2012/05/11/generate-sql-server-test-data-from-excel-the-transfer-to-sql-server-and-2.aspx[^]

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