when i performed the Select * from [Sheet1$]… the excel didn’t have a header, does this mean that its taking my row 0 which is actual data as a header. please How do i make it read with its own default headers as my excel doesn’t have headers
I mean even if your excel dont have headers, you can specify HDR=NO in your connection string and the columns will be F1,F2,F3… and your query will be like: select * from [Sheet1$] where [F8] in ('2','1')