将Excel Workhseet导入SQL Server 2008 [英] Import Excel workhseet into SQL Server 2008

问题描述

我正在使用此语法将Excel文件读入SQL Server Management Studio 2008

I am using this syntax to read my excel file into SQL Server Management Studio 2008

SELECT * 
FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',
                ''Excel 8.0;Database=C:\proj\test.xls'',
                ''SELECT * FROM [Sheet1$]'')

但这会引发错误

But it throws error

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.

我怀疑Windows XP上未安装JET OLEDB.尽管我确实在System32文件夹中看到MsJet40.dll dll

当我在控制面板"中查看时->管理员工具-> ODBC Admin，我在驱动程序列表中没有看到OLE DB.这可能是一个问题.如果是，有人可以指导我如何安装它.

我去了 http://support.microsoft.com/kb/239114 [

I am suspecting JET OLEDB is not installed on my Windows XP. Although I do see the MsJet40.dll dll in System32 folder

When I look in Control Panel -> Adminstrators tools -> ODBC Admin, I do not see OLE DB in the drivers list. Could this a problem. If yes can someone guide me how to install it.

I went to http://support.microsoft.com/kb/239114[^] but after installation, it says I already have the latest updates. Can someone help.

推荐答案

'')

但这会引发错误

But it throws error

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.

我怀疑Windows XP上未安装JET OLEDB.尽管我确实在System32文件夹中看到MsJet40.dll dll

当我在控制面板"中查看时->管理员工具-> ODBC Admin，我在驱动程序列表中没有看到OLE DB.这可能是一个问题.如果是，有人可以指导我如何安装它.

我去了 http://support.microsoft.com/kb/239114 [

I am suspecting JET OLEDB is not installed on my Windows XP. Although I do see the MsJet40.dll dll in System32 folder

When I look in Control Panel -> Adminstrators tools -> ODBC Admin, I do not see OLE DB in the drivers list. Could this a problem. If yes can someone guide me how to install it.

I went to http://support.microsoft.com/kb/239114[^] but after installation, it says I already have the latest updates. Can someone help.

尝试此链接
http://dotnetslackers.com/articles/sql/Importing- MS-Excel-data-to-SQL-Server-2008.aspx [

try this link
http://dotnetslackers.com/articles/sql/Importing-MS-Excel-data-to-SQL-Server-2008.aspx[^]

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