I am writing a select query using opendatasource to get data from an excel file.
There are 100s of columns in the file and i want to select only columns whose name starts with "MR"
e.g. if there are columns MR1, MR4, MR5, GG1, something5
The select query will return only MR1, MR4 and MR5
Note: The number of columns in the excel file is not constant and the count of columns starting with MR may change because of which i cannot hardcode these names.
Need help on this urgently as i am stuck.
Thanks in advance