I use ADODB in Excel VBA to retrieve data from a closed workbook. I can select all columns, select individual columns by column header. This works perfectly.

But how can I read the values of columns 1, 2 and 3, for example, without specifying the column titles? So far I have tried for example “SELECT F1, F2, F3 FROM [sales$];”. But I get an error when I open the recordset