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

What are the way开发者_开发百科s to pull info from an Access DB to powershell?

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.

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