I have a password protected EXCEL spreadsheet. I supplied the pwd, had the file open, built ODBC connection and successfully connected to the file with SQL SELECT. However the header I wanted was not the 1st row so the Header became Row 1 (Report 1, F2, F3, ....) and Row 2 and below became data.

How do I get the value of the Row 4 (EIN, WORKER NAME, LEGAL ENTITY) and make it as header? In non-encrypted EXCEL we can use Embedded Label but what do I do here?

Thanks Anand and Rob. The field names will be dynamic so hardcoding is impossible. The row of the header could change too. The header could be row 4, row 5, or row 6. This is messy and thank you in advance!