[VB.NET]高分:求一个在vb.net2005中用ado.net读取excel文件并将其导入到Acess的示例!

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
高分:求一个在vb.net2005中用ado.net读取excel文件并将其导入到Acess的示例!
如题,这样吧,分两个示例也行,分数各给一半!
__________________________________________________________________________
sf +up
__________________________________________________________________________
在线急等
__________________________________________________________________________
自己写的代码,结果出现 找不到可安装的 ISAM。
Sub excels()
Dim conn As New OleDb.OleDbConnection( Provider=Microsoft.jet.oledb.4.0;data source=data.xls;Extended Properties=Excel 11.0 )
Dim adp As New OleDb.OleDbDataAdapter( select * from [sheet1$] , conn)
Dim ds As New DataSet
--> adp.Fill(ds, link )
Me.DataGridView1.DataSource = ds.Tables(0).DefaultView
End Sub
data.xls文件就在当前目录中,而网上查了半天还是没弄懂到底是怎么回事!
检查了下
__________________________________________________________________________
哭泣^^
__________________________________________________________________________
给你个：
http://blog.csdn.net/net_lover/archive/2006/12/02/1426092.aspx
__________________________________________________________________________
上面给你的是反例，换个方向即可。
__________________________________________________________________________
谢谢,看看先!
__________________________________________________________________________
用sql语句可以吗?
__________________________________________________________________________
Provider=Microsoft.Jet.OLEDB.4.0;Data Source= & execl_Filename & ; Extended Properties=Excel 8.0;
试试！
__________________________________________________________________________
上面excel数据ado.net读入的问题总算是堪堪解决！但excel导入的数据不能用datatable，一旦使用会出现类型转换错误，也就无法添加主键，导致oledbcommandbulider对象无效！郁闷啊！
继续请大家帮忙！
__________________________________________________________________________