How to get a list of installed OLE DB providers?

Question

Microsoft Excel allows import of data from "Other Sources". One of the options is to use an OLE DB provider.

How to get a list of available OLE DB providers?

Answer 1

If you have powershell available, just paste this into a powershell command prompt:

foreach ($provider in [System.Data.OleDb.OleDbEnumerator]::GetRootEnumerator()) {     $v = New-Object PSObject             for ($i = 0; $i -lt $provider.FieldCount; $i++)      {         Add-Member -in $v NoteProperty $provider.GetName($i) $provider.GetValue($i)     }     $v } 

Credits and more advanced usage: http://dbadailystuff.com/list-all-ole-db-providers-in-powershell