×
英语
很抱歉。本文没有你的语言版本。

Data source prerequisites (Power Query)

Use Excel's Get & Transform (Power Query) experience to connect to various data sources. For each provider, Power Query supports a specific provider version and objects. For guidance on importing data from various sources, see Import data from external data sources.

Data source

Provider

Min. provider version

Min. data source version

Supported data source objects

Download

SQL Server

ADO.net (built into .Net Framework)

.Net Framework 3.5 (only)

SQL Server 2005+

  • Tables/Views

  • Scalar functions

  • Table functions

Included in .NET Framework 3.5 or above

Access

Microsoft Access Database Engine (ACE)

ACE 2010 SP1

No restriction

  • Tables/Views

Link

Excel (.xls files only) 1

Microsoft Access Database Engine (ACE)

ACE 2010 SP1

No restriction

  • Tables

  • Sheets

Link

Oracle 2

ODP.NET

ODAC 11.2 Release 5 (11.2.0.3.20)

9.x+

  • Tables/Views

Link

System.Data.OracleClient (Built in .Net Framework)

.NET Framework 3.5

9.x+

  • Tables/Views

Included in .NET Framework 3.5 or above

IBM DB2

ADO.Net client from IBM (part of the IBM data server driver package)

10.1

9.1+

  • Tables/Views

Link

MySQL

Connector/Net

6.6.5

5.1

  • Tables/Views

  • Scalar functions

Link

PostgreSQL

NPGSQL ADO.NET provider

2.0.12

7.4

  • Tables/Views

Link

Teradata

.NET Data Provider for Teradata

14+

12+

  • Tables/Views

Link

SAP Sybase SQL Anywhere

iAnywhere.Data.SQLAnywhere for .NET 3.5

16+

16+

  • Tables/Views

Link

DB2 for z/OS

  • Tables/Views

DB2 for i

  • Tables/Views

DB2 for LUW (Linux, UNIX, Windows)

  1. Excel files that have an .xlsx extension do not require a separate provider installation.

  2. The Oracle providers also require Oracle client software (version 8.1.7+).

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Power Query is known as Get & Transform in Excel 2016

Import data from external data sources

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×