'')

但这会引发错误

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[^]