da.SelectCommand = New System.Data.OleDb.OleDbCommand conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & System.Configuration.ConfigurationSettings.AppSettings.Get("CSDPath").ToString & ";Extended Properties=""Excel 8.0;HDR=No;IMEX=1""" da.SelectCommand.CommandText = "SELECT * FROM [Sheet1$]" da.SelectCommand.CommandType = CommandType.Text da.SelectCommand.Connection = conn da.Fill(ds, "CSD Rates")