Hi All.
Looking to keep my queries as fast as possible - and user friendly and modifiable (by the non sql user).
1) Is there a way to use a named range (from a sheet in the file) in my Power Query "From ODBC" Advance options Sql? I am querying an oracle database and by using the advanced options, SQL, my data set can be filtered at the source - Much faster. But, I would like to be able to have the "Where" statement use a range of cells. Can it be done?
I can use a named range of cells (= Excel.CurrentWorkbook(){[Name="User_ID"]}[Content]) to create a "table" to use to filter the results of #1 above, but that filters them after I have retrieve the original dataset from the oracle server. Slower...
I have as my original query / data set...
2) In the where statement above, I would like to be able to have the "PROGRAMS.DML_USER_ID" be a range in the local excel file. Can it be done???Please Login or Register to view this content.
3) Can I use vba to concatenate a where statement to be added to the original sql?
4) Can I have a vba function return a statement to the "where" sql for the original data set?
5) I can create a VBA DAO data set from an sql statement to oracle where I can create (in vba) the entire sql statement. Can this be the data source in power query?
Thanks.
Steve
Harrisburg, PA
Bookmarks