导入Excel文件时出现连接错误 [英] connecting error for import the excel file

问题描述

我无法使用以下连接字符串在x64服务器上使用.NET打开Excel电子表格:

I can''t open an Excel spread sheet with .NET on an x64 server using the following connection string:

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + filePath + "; Extended Properties=Excel 8.0;"

我得到Microsoft.Jet.OLEDB.4.0提供程序未在本地计算机上注册.
我们该如何解决呢?请帮帮我.

感谢

I get The Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine.
How we can solve it? Please help me.

thanks

推荐答案

ConnectionString ="Provider = Microsoft.Jet.OLEDB.4.0; Data Source = OriginExcelFile扩展属性= Excel8.0; HDR = Yes; IMEX = 1"

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= OriginExcelFile Extended Properties=Excel8.0;HDR=Yes;IMEX=1"

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