When setting up a Microsoft Query connection (to an Oracle table/view via ODBC) in Excel 2016:
Problem:
I have hundreds of Oracle views to scroll through in order to get to the view that I want:
Manually scrolling through that many views is tedious, especially when adding multiple connections to a spreadsheet.
Question:
Is there an easier way to navigate to a specific view in the list of objects in Microsoft Query?