MapObjects 表连接Excel的问题

<P> 我在C#的环境中,想要连接一张Excel表.添加了Microsoft Excel 9.0 object Library。</P>
<P>我的代码如下：</P>
<P>            MapObjects2.Table tb = new MapObjects2.TableClass();<BR>            tb.Database = "EXCEL 9.0; DATABASE="<a href='mailt+@"F:\EveryDataWork\TestAdd.xls' target="_blank" >+@"F:\EveryDataWork\TestAdd.xls</A>";<BR>            tb.Name = "AddTable$";//AddTable是TestAdd.xls的一个sheet</P>
<P>           MapObjects2.Record rect = tb.Records;</P>
<P>           结果错了，我修改tb.Name = "AddTable";还是错了，有哪位指点下吗，非常谢谢。</P>

<P>ESRI.MapObjects2.Core.Table tb=new ESRI.MapObjects2.Core.TableClass();<BR>   tb.Database= "EXCEL 8.0; DATABASE=c:\\excel.xls";<BR>   tb.Name="xyz$";<BR>  <BR>  ESRI.MapObjects2.Core.Recordset recd =tb.Records;</P>
<P>这样就ok了，如果用Excel 9.0或者Excel 10.0都会提示错误 The Recordset could not be created.</P>
<P>Try using Excel 8.0 as your connection string. It will connect to all versions of excel, 2000 and xp. This should fix your problem. </P>

<img src="images/post/smile/dvbbs/em04.gif" />