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