Forum Discussion
VBA_ENTHU1988
Nov 09, 2021Copper Contributor
Search a List of Table names in SQL
Hi, I have multiple SQL's generally each one having 100+ lines of SQL code , Swcond I have a list of tables stored in Excel column wise Task -- I want to search if any of these table name...
VBA_ENTHU1988
Nov 11, 2021Copper Contributor
Actually i was trying to separate the table names from the query maybe by using macros and then once that is separated we can easily make a vlookup or something
SergeiBaklan
Nov 11, 2021Diamond Contributor
That doesn't matter what to use. Macros, poor formulas, Power Query, whatever. Without the formal logic for parsing non of them works.