Run SQL against Excel and Access through Access Database Engine with PowerShell – Part 1

This is part 1 of a series of blog posts around using SQL against Excel and Access through ACE drivers (Access database engine) with PowerShell. Part 1 is about introduction and getting up and running. PowerShell has already some built-in support to slice and dice data via the select, where, and group cmdlets. If it …