locked
mdc-Files in PowerPivot RRS feed

  • Question

  • Hello together,

    I´ve got an question concerning the data you can handle with in PowerPivot. Is it possible to integrate mdc-Files in PowerPivot?

    Thanks a lot

    Nico

    Tuesday, June 11, 2013 11:39 AM

Answers

  • Hello Nico,

    Please take a look at the following table about Data Sources Supported in PowerPivot Workbooks:

    Source

    Versions

    File type

    Providers 1

    Access databases

    Microsoft Access 2003, 2007, 2010.

    .accdb or .mdb

    ACE 14 OLE DB provider

    SQL Server relational databases

    Microsoft SQL Server 2005, 2008, 2008 R2, SQL Server 2012; Microsoft SQL Azure Database 2

    (not applicable)

    OLE DB Provider for SQL Server

    SQL Server Native Client OLE DB Provider

    SQL Server Native 10.0 Client OLE DB Provider

    .NET Framework Data Provider for SQL Client

    SQL Server Parallel Data Warehouse (PDW) 3

    2008 R2, SQL Server 2012

    (not applicable)

    OLE DB provider for SQL Server PDW

    Oracle relational databases

    Oracle 9i, 10g, 11g.

    (not applicable)

    Oracle OLE DB Provider

    .NET Framework Data Provider for Oracle Client

    .NET Framework Data Provider for SQL Server

    MSDAORA OLE DB provider 4

    OraOLEDB

    MSDASQL

    Teradata relational databases

    Teradata V2R6, V12

    (not applicable)

    TDOLEDB OLE DB provider

    .Net Data Provider for Teradata

    Informix relational databases

     

    (not applicable)

    Informix OLE DB provider

    IBM DB2 relational databases

    8.1

    (not applicable)

    DB2OLEDB

    Sybase relational databases

     

    (not applicable)

    Sybase OLE DB provider

    Other relational databases

    (not applicable)

    (not applicable)

    OLE DB provider or ODBC driver

    Text files

    (not applicable)

    .txt, .tab, .csv

    ACE 14 OLE DB provider for Microsoft Access

    Microsoft Excel files

    Excel 97-2003, 2007, 2010

    .xlsx, xlsm, .xlsb, .xltx, .xltm

    ACE 14 OLE DB provider

    PowerPivot workbook

    Microsoft SQL Server 2008 R2 and SQL Server 2012 Analysis Services

    xlsx, xlsm, .xlsb, .xltx, .xltm

    ASOLEDB 10.5

    (used only with PowerPivot workbooks that are published to SharePoint farms that have PowerPivot for SharePoint installed)

    Analysis Services cube

    Microsoft SQL Server 2005, 2008, 2008 R2, SQL Server 2012 Analysis Services

    (not applicable)

    ASOLEDB 10

    Data feeds

    (used to import data from Reporting Services reports, Atom service documents, Microsoft Azure Marketplace DataMarket, and single data feed)

    Atom 1.0 format

    Any database or document that is exposed as a Windows Communication Foundation (WCF) Data Service (formerly ADO.NET Data Services).

    .atomsvc for a service document that defines one or more feeds

    .atom for an Atom web feed document

    Microsoft Data Feed Provider for PowerPivot

    .NET Framework data feed data provider for PowerPivot

    Office Database Connection files

     

    .odc

     

    For detail information, please see: http://technet.microsoft.com/en-us/library/gg399082.aspx

    Best Regards,


    Elvis Long
    TechNet Community Support

    • Edited by Elvis Long Monday, June 17, 2013 7:26 AM
    • Marked as answer by Elvis Long Wednesday, June 19, 2013 8:43 AM
    Monday, June 17, 2013 7:25 AM