Question

请问excel表怎么导入到VB中的datagrid？

我想实现datagrid表内容的导入导出，导出到excel已经搞定，导入一直不会弄，就是把excel表的内容导入到datagrid1，哪位高手给个代码呀？我是新手，什么都不会！所以请给个详细的代码

Answer 1

Dim adoCon As New ADODB.Connection
Dim adoRs As New ADODB.Recordset
adoCon.CursorLocation = adUseClient
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\123.xls;Extended Properties='Excel 8.0;HDR=yes;IMEX=1'"
If adoRs.State <> adStateClosed Then adoRs.Close
adoRs.CursorLocation = adUseClient
adoRs.Open "select * from [sheet1$]", adoCon, adOpenStatic, adLockReadOnly
Set DataGrid1.DataSource = adoRs
看看这个行不行

Answer 2

为什么非要EXCEL啊，用ACCESS啊！
EXCEL功能十分有限

http://hi.baidu.com/freewolf/blog/item/674a0b24f1680a37c99559a9.html