I have the following:
string oledbcmd = ""; string constr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Excel.xls;@Extended Properties='Excel 8.0;HDR=Yes;"; oledbcmd = "Select top (1) * From [CLIENTES$] ORDER BY id desc"; OleDbCommand oconn = new OleDbCommand(oledbcmd, con); OleDbDataAdapter sda = new OleDbDataAdapter(oconn); DataTable data = new DataTable(); sda.Fill(data);
It fails. What is wrong with that query? I want to get the last row that was inserted.