I have writeen following code to retrieve data from Excel to Datagrid, but problem is it&#039;s only displaying non-numeric cell values. What&#039;s wrong with code?<BR><BR>Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _<BR> "Data Source=" & Replace(Server.MapPath("."), "\", "\") & "\exceltest.xls;" & _<BR> "Extended Properties=""Excel 8.0;"""<BR><BR> &#039;You must use the $ after the object you reference in the spreadsheet<BR> Dim myOleDbDataAdapter As New System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn)<BR> myOleDbDataAdapter.Fill(myDataset)<BR><BR> DataGrid1.DataSource = myDataset.Tables(0).DefaultView<BR> DataGrid1.DataBind()