Good morning everyone, I have to do a sample from Excel, but I don’t have everything, and only 1 and 4 columns (1 column is from A6 to A11, and the second from C4 to C8), how to build a query, I tried this:

OleDbCommand MyCommand = new OleDbCommand("select * from [Sheet1$A6:A11,C4:C8]", MyConnection);

But it does not work: (How to build correctly?

    1 answer 1

     MyCommand = new OleDbDataAdapter(@"select [Операция], [Код модели/артикул] from [rem$]", MyConnection);

    This is how to take a 2-va column entirely.