title: Connect to Microsoft Access DB/SharePoint List with Powershell
body: <p>I'm trying to connect to a Microsoft Access database, hosting a SharePoint List, with Powershell. However I can't seem  to find accurate information online demonstrating how to do this. I'm relatively new to SharePoint but am comfortable with Powershell.</p>
  
  <p>The closest demonstration I've found is from the Microsoft Scripting Guys, in the first script on <a href="https://blogs.technet.microsoft.com/heyscriptingguy/2009/08/13/hey-scripting-guy-can-i-query-a-microsoft-access-database-with-a-windows-powershell-script/" rel="nofollow noreferrer">this page</a>:</p>
  
  <pre><code>$path = "C:dataScriptingGuysHSG_8_10_09HighJumperDatabase.mdb"
  $adOpenStatic = 3
  $adLockOptimistic = 3
  
  $cn = new-object -comobject ADODB.Connection
  $rs = new-object -comobject ADODB.Recordset
  
  $cn.Open("Provider = Microsoft.Jet.OLEDB.4.0;Data Source = $path")
  $rs.Open("SELECT TOP 1 [High Jumper Data].[Name], 
    [High Jumper Data].[Personal Best], [High Jumper Data].[Season Best] 
    FROM [High Jumper Data]
    ORDER BY [High Jumper Data].[Personal Best] 
    DESC , [High Jumper Data].[Season Best] DESC", 
    $cn, $adOpenStatic, $adLockOptimistic)
  
  $rs.MoveFirst()
  Write-host "The winner will likely be " $rs.Fields.Item("Name").Value
  </code></pre>
  
  <p>Unfortunately I've never used ADO, and am unsure of what the <code>Provider</code> parameter here is referring to. </p>
  
  <p>My objective is to query the SharePoint List for certain information, and then copy that information to another location. Are there comparable PowerShell objects/commands that replicate this script for this purpose?  Or do I need to learn ADO in order to access my SharePoint List on Access?  </p>