Hi,
We have a need to import an excel file data to SQL. That excel file has some of the column header values to be of rolling months based on Excel formula looking up another sheet value.
Im using OLE DB connection manager for connecting with Excel file. I am trying to capture only the column headers. Now, for the column header being static values come as such, But, for the column header being formulae driven (rolling months) are showing up as some numeric values instead of the column header showing up values.
How to take only the column header value? as like we do copy only the values in excel sheet?
- Thank you!