Hello,

How do you manage embedded queries that exist in excel sheets?

When I swap out a table, in our SQL2010 server, I search our database objects for uses of that table name and update those objects to use the new table name. Unfortunately, when the query is embedded in a excel table, it is outside the scope of the database search function.

Generally, we do not use embedded queries, but for short term excel reports it is still commonly done. unfortunately these "short term" reports mostly become permanent additions.

Does anyone know of a way to search a collection of excel sheets for a connection text that contains a specific tableName, MyClients for example?