用vb.net如何连接到Excel数据库？

[ADO_NET]

用vb.net如何连接到Excel数据库？高手帮忙！ 谢谢

[包建强]

string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = c:\\test.xls;Extended Properties=Excel 8.0" ;
OleDbConnection myConn = new OleDbConnection (strCon) ;
myConn.Open() ;
string strCom = " SELECT Category,Comp_Num FROM [Sheet1$] " ;
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom,myConn);

dataSet1 = new DataSet();
myCommand.Fill (dataSet1 , "[Sheet1$]");

myConn.Close();