Cool PDM tool: embed an SQL query within Excel

One of the things I love most about attending SolidWorks World (SWW) is the learning. As someone who teaches regularly, it’s great to meet up with colleagues and customers and learn from them how they have applied their learnings to solve unique customer challenges.

One such meeting I had was with Ernie Noyce, an Application Engineer with TriMech Solutions. Ernie showed me how he was executing T-SQL queries from within an Excel spreadsheet to generate status reports.

The status reports were tied to the Enterprise PDM database and detailed the various workflow states in the vault, which documents were in each state, and how long each document had been in each state.

He utilized a freeware tool appropriately called SQL Excel. You can learn more about this tool at: https://www.sqlexcel.net/