如何获取已安装的OLE DB提供程序的列表? [英] How to get a list of installed OLE DB providers?

问题描述

Microsoft Excel允许从其他来源"导入数据.一种选择是使用OLE DB提供程序.

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

如何获取可用的OLE DB提供程序的列表?

How to get a list of available OLE DB providers?

推荐答案

如果有可用的powershell，只需将其粘贴到powershell命令提示符下即可:

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
}

积分和更高级的用法: http://dbadailystuff.com/list-all-ole-db-providers -in-powershell

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

这篇关于如何获取已安装的OLE DB提供程序的列表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！