very easy small question:c#导入excel的问题。

SmallCase 2003-06-20 05:06:39
欲导入excel文件作为dataset来填充datagrid,已经将excel9.olb转化,并将Microsoft Excel 10.0添加项目引用了,我的是xp+officexp+sql2000+.net1.0.3705
代码:
private void Form1_Load(object sender, System.EventArgs e)
{
string connstr="provider=Microsoft.Jet.OLEDB.4.0;Data Source=myexcel.xls;Extended Properties=\"Excel 8.0\";HDR=yes;";
OleDbConnection conn=new OleDbConnection();
try
{
conn.ConnectionString=connstr;
conn.Open();
}
catch(OleDbException ex)
{
MessageBox.Show(ex.Message);
}
conn.Close();

}
错误提示:未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中
捕捉错误后错误提示:找不到可安装的ISAM
请问还有那些配置要修改还是代码不对?请高手指点!
...全文
46 4 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
小伍老师 2003-06-25
  • 打赏
  • 举报
回复
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ fileName2 +";Extended Properties=Excel 8.0;"
SmallCase 2003-06-25
  • 打赏
  • 举报
回复
楼上兄弟提供的是Excel文件操作,我想将Excel文件作为数据库导入,并能进行操作,问题仍然没有解决。大家来帮忙!
SmallCase 2003-06-21
  • 打赏
  • 举报
回复
请高手指点!
烤火的鱼 2003-06-21
  • 打赏
  • 举报
回复
http://www.uncj.net/Exce.htm
Twitter Digg Facebook Del.icio.us Reddit Stumbleupon Newsvine Technorati Mr. Wong Yahoo! Google Windows Live Send as Email Add to your CodeProject bookmarks Discuss this article 85 Print Article Database » Database » Other databasesLicence CPOL First Posted 19 Jan 2012 Views 24,219 Downloads 992 Bookmarked 74 times RaptorDB - The Key Value Store V2 By Mehdi Gholam | 8 Mar 2012 | Unedited contribution C#.NETDBABeginnerIntermediateAdvanceddatabase Even faster Key/Value store nosql embedded database engine utilizing the new MGIndex data structure with MurMur2 Hashing and WAH Bitmap indexes for duplicates. See Also More like this More by this author Article Browse Code Stats Revisions (8) Alternatives 4.95 (56 votes) 1 2 3 4 5 4.95/5 - 56 votes μ 4.95, σa 1.05 [?] Is your email address OK? You are signed up for our newsletters but your email address is either unconfirmed, or has not been reconfirmed in a long time. Please click here to have a confirmation email sent so we can confirm your email address and start sending you newsletters again. Alternatively, you can update your subscriptions. Add your own alternative version Introduction What is RaptorDB? Features Why another data structure? The problem with a b+tree Requirements of a good index structure The MGIndex Page Splits Interesting side effects of MGIndex The road not taken / the road taken and doubled back! Performance Tests Comparing B+tree and MGIndex Really big data sets! Index parameter tuning Performance Tests - v2.3 Using the Code Differences to v1 Using RaptorDBString and RaptorDBGuid Global parameters RaptorDB interface Non-clean shutdowns Removing Keys Unit tests File Formats File Format : *.mgdat File Format : *.mgbmp File Format : *.mgidx File Format : *.mgbmr , *.mgrec History Download RaptorDB_v2.0.zip - 38.7 KB Download RaptorDB_v2.1.zip - 39 KB Download RaptorDB_v2.2.zip - 39 KB Download RaptorDB_v2.3.zip - 39.6 KB D

111,098

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术 C#
社区管理员
  • C#
  • AIGC Browser
  • by_封爱
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

让您成为最强悍的C#开发者

试试用AI创作助手写篇文章吧