C#

<br />
// Create connection string variable. Modify the "Data Source"<br />
// parameter as appropriate for your environment.<br />
string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=@C:\\Test.xls;" + "Extended Properties=Excel 8.0;" + "HDR=Yes;IMEX=1";<br />
<br />
// Create connection object by using the preceding connection string.<br />
OleDbConnection objConn = new OleDbConnection(sConnectionString);<br />
<br />
// Open connection with the database.<br />
objConn.Open();<br />
<br />
// The code to follow uses a SQL SELECT command to display the data from the worksheet.<br />
// Create new OleDbCommand to return data from worksheet.<br />
OleDbCommand objCmdSelect =new OleDbCommand("SELECT * FROM [Tabelle1$]", objConn);   <--- An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll<br />
<br />
// Create new OleDbDataAdapter that is used to build a DataSet<br />
// based on the preceding SQL SELECT statement.<br />
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();<br />
<br />
// Pass the Select command to the adapter.<br />
objAdapter1.SelectCommand = objCmdSelect;<br />
<br />
// Create new DataSet to hold information from the worksheet.<br />
DataSet objDataset1 = new DataSet();<br />
<br />
// Fill the DataSet with the information from the worksheet.<br />
objAdapter1.Fill(objDataset1, "XLData");<br />
<br />
// Bind data to DataGrid control.<br />
dataGrid1.DataSource = objDataset1.Tables[0].DefaultView;<br />
dataGrid1.DataBind();           <-------- System.Windows.Forms.DataGrid' does not contain a definition for 'DataBind'<br />
<br />
// Clean up objects.<br />
objConn.Close();<br />