使用C#和oledb从Excel 2010中获取数据 [英] Getting data from excel 2010 using c# and oledb

问题描述

继续获取找不到可安装的ISAM"错误.
操作系统是Windows 7 64位
MS Office是2010年
使用以下命令生成错误:
字符串ced ="Provider = Microsoft.ACE.OLEDB.12.0;数据源= d:\\ alan.xlsx;扩展属性= \" Excel14.0; HDR = YES; IMEX = 1; \";
OleDbConnection ced5 =新的OleDbConnection(ced);
ced5.Open();
尝试打开连接时生成错误
已在网上查看-很多建议，但尚未解决

Keep getting "couldn''t find installable ISAM" error.
OS is Windows 7 64bit
MS Office is 2010
Error is generated using the following:
string ced = "Provider = Microsoft.ACE.OLEDB.12.0;Data Source = d:\\alan.xlsx;Extended Properties=\"Excel14.0;HDR=YES;IMEX=1;\"";
OleDbConnection ced5 = new OleDbConnection(ced);
ced5.Open();
Error is generated when trying to open the connection
Have looked on web - lots of advice but no fixes as yet

推荐答案

尝试此解决方案. http://support.microsoft.com/kb/90111 [

Try this solution. http://support.microsoft.com/kb/90111[^]

这篇关于使用C#和oledb从Excel 2010中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！