How to use powershell to send SQL command to Access DB and return results?

Question

What are the ways to pull info from an Access DB to powershell?

Answer 1

There isn't a built-in cmdlet to do this. However you still have several options.

1. Use sqlcmd.exe - it stills works in PowerShell

2. SQL PowerShell Extensions

3. Use Invoke-AdoCommand - this is in the PowerShell Community Extensions

4. Drop down to the ADO.NET classes and program it.

Fortunately somebody else has written up that last one.

Answer 2

You've already got an answer that works but also visit Richard Siddaway's Blog Of PowerShell and Other Things with the Access tag