Parameters   Output Objects  

Searches Microsoft Access data.

Syntax

Select-Access [parameters]

Remarks

The Select-Access cmdlet allows you to use a syntax similar to SQL SELECT statements to search Microsoft Access data.

$conn = Connect-Access -DataSource 'C:\my.accdb'
Select-Access -Connection $conn -Table "Orders" -Columns @("ShipName","ShipCity") -Where "ShipCountry='USA'"