ETL and Data Integration tools - Modern ETL software for everyone

I'm trying to add contents of cell B3 on worksheet "ALL AREA CODES" into the extract to store into column effective_date.
How do I do this?

George

George

You can query any part of excel file by using

Unnamed Range

To specify an unnamed range of cells as your record source, append standard Excel row/column notation to the end of the sheet name in the square brackets. For example:
SELECT * FROM [Sheet1$A1:B10]


select * from "ALL AREA CODES$B2:B3", <===== That is the solution
"'ALL AREA CODES$'FilterDatabase"

Excel is tricky to extract the data from...

Mike