Share via

Get data from Microsoft Exchange in Excel

Anonymous
2021-08-02T13:27:37+00:00

I cannot seem to "get data" from Microsoft Exchange in MS Excel. Can somebody help? It is not even appearing as an option. I have just subscribed to Office 365 Business Standard package.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-08-04T13:30:03+00:00

    Its ok I have sorted it through Google Sheets now without using exel.

    Thanks,

    Joe.

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-08-08T09:23:15+00:00

    Hi Joe,

    After further investigation, we found that the problem is caused by version differences.

    Since you said that you purchased Office 365 Business Standard, which means you installed Microsoft 365 for Business, however, it has fewer connectors than Microsoft 365 for Enterprise.

    Here are the details:

    Get Data in Excel in Microsoft 365 for Business:

    -      From File: From Workbook, From Text/CSV, From XML, From JSON, From PDF, From Folder

    -      From Database: From SQL Server Database, From Microsoft Access Database, From Analysis Services, From SQL Server Analysis Services Database (Import)

    -      From Azure: From Azure Data Explorer

    -      From Online Services

    -      From Other Sources: From Table/Range, From Web, From Microsoft Query, From OData Feed, From ODBC, From OLEDB, From Blank Query

    Get Data in Excel in Microsoft 365 for Enterprise:

    -      From File: From Workbook, From Text/CSV, From XML, From JSON, From PDF, From Folder, From SharePoint Folder

    -      From Database: From SQL Server Database, From Microsoft Access Database, From Analysis Services, From SQL Server Analysis Services Database (Import), From Oracle Database, From IBM Db2 Database, From MySQL Database, From PostgreSQL Database, From Sybase Database, From Teradata Database, From SAP HANA Database

    -      From Azure: From Azure Data Explorer, From Azure SQL Database, From Azure Synapse Analysis, From Azure HDInsight (HDFS), From Azure Blob Storage, From Azure Table Storage, From Azure Data Lake Storage

    -      From Online Services: From SharePoint Online List, From Microsoft Exchange Online, From Dynamics 365 (online), From Salesforce Objects, From Salesforce Reports

    -      From Other Sources: From Table/Range, From Web, From Microsoft Query, From SharePoint List, From OData Feed, From Hadoop File (HDFS), From Active Directory, From Microsoft Exchange, From ODBC, From OLEDB, From Blank Query

    Best Regards,

    Arck

    11 people found this answer helpful.
    0 comments