Tip from Dan Cory: Can use select * from [Sheet1$A2:G10] in Custom SQL for Excel sources.
Can use Custom SQL to reference specific cells in Excel
Leave a reply
Tip from Dan Cory: Can use select * from [Sheet1$A2:G10] in Custom SQL for Excel sources.