Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am fetching data from xlsb (Binary file). I have created ODBC connection for this file but I am not able to fetch columns of a particular table as header are starting from 3rd row. Is there any feature as we have in Excel (Embedded labels and Header line ) to fetch proper field names. currently names are coming as F1, F2,F3 and so on.
Piyush.
Hi,
Try like this.. (if your headers are static in the row 3)
ODBC CONNECT32 TO [Excel Files;DBQ=FilePath\FileName.xlsb];
LOAD F1 as FieldName1,
F2 as FieldName2,
F3 as FieldName3,
F4 as FieldName4
Where RecNo()>3;
SQL SELECT *
FROM `FilePath\FileName.xlsb`.`Sheet1$`;
Hi settu,
Even though my headers are static (not freeze) on 3 rd row. but when I reload it using above script (without alias) data coming but not header. could you please explain why this is happening.
Thanks,
Piyush Jain
Can you make it as ">=3" instead of ">3 ?
Hi settu,
I tried the same. even I have tried >2. still its picking up the data but not picking the header.
Thanks
Can you post the sample file?