Salve mi serve aiuto, non so cosa mettere in command.text dove sta scritto sheet, grazie in anticipo
codice:DataTable dt = new DataTable(); string fileName = @"C:\Users\Domenico.DESKTOP-KDBNQN1\Downloads\prova.xlt"; using (OleDbConnection conn = new OleDbConnection()) { conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";" + "Extended Properties='Excel 8.0;HDR=YES;'"; using (OleDbCommand comm = new OleDbCommand()) { comm.CommandText = "SELECT Id,Nome,Cognome FROM[Sheet1$]"; comm.Connection = conn; using (OleDbDataAdapter da = new OleDbDataAdapter()) { da.SelectCommand = comm; da.Fill(dt); } } } }