Learn more
 

CData Software - Knowledge Base

Recent MySQL Excel Articles

Query Excel Online in MySQL Workbench

Create a virtual MySQL database for Microsoft Excel Online in CData Software Connect (or Connect Server) and work with live Microsoft Excel Online in MySQL Workbench.

Access SharePoint Excel Services from MySQL in PHP

Connect to SharePoint Excel Services through the standard MySQL libraries in PHP.

Use the CData ODBC Driver for MySQL from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for MySQL to connect to MySQL from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MySQL in Excel.

How to Query Excel Online in MySQL Workbench

Execute MySQL queries against live Microsoft Excel Online from MySQL Workbench.

Automated Continuous Excel Replication to MySQL

Use CData Sync for automated, continuous, customizable Excel replication to MySQL.

Create Reports from Excel Online in Looker Studio

Use CData Connect Cloud to gain access to live Microsoft Excel Online and create custom reports in Looker Studio.

Explore Geographical Relationships in MySQL with Power Map

Create data visualizations with MySQL in Power Map.

Build Visualizations of Live Excel in Power BI (through CData Connect)

Use CData Connect to create a virtual database for Microsoft Excel and build custom reports in Power BI.

Automated Continuous SharePoint Excel Services Replication to MySQL

Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to MySQL.

Query Excel Online as a MySQL Database in Node.js

Execute MySQL queries against Microsoft Excel Online from Node.js.

Access Excel Online from MySQL in PHP

Connect to Excel Online through the standard MySQL libraries in PHP.

Author and Share Power BI Reports on Real-Time MySQL

Use the CData ODBC Driver for MySQL to visualize MySQL in Power BI Desktop and then upload to the Power BI service.

How to Query SharePoint Excel Services in MySQL Workbench

Execute MySQL queries against live SharePoint Excel Services from MySQL Workbench.

How to update MySQL from Excel

This article explains how to transfer data from Excel to MySQL using the Excel Add-In for MySQL.

A PostgreSQL Interface for Excel Online

Use the Remoting features of the Excel Online ODBC Driver to create a PostgreSQL entry-point for data access.