6 Replies Latest reply: Jul 15, 2014 10:44 AM by Jessica Tung RSS

    Read row as header in SQL select (pwd protected spreadsheet)

      Hi,

       

      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?

       

      header.PNG.png