IntegrationODBC/5 tutorials

Microsoft Excel data integration tutorials

Tutorials for querying live business data from Microsoft Excel with Microsoft Query and CData ODBC drivers, including parameters, joins and refreshing.

What this integration does

Microsoft Query is the legacy data import wizard in Excel for Windows. It works with any ODBC data source, so once a system is exposed through ODBC you can run SQL against it, bring the rows into a worksheet and drive a filter from a cell. The workbook stays connected to the source, which means a refresh returns current rows without another export.

How CData fits in

CData ODBC drivers present SAP, Jira, SharePoint, Snowflake, Active Directory and hundreds of other sources as ordinary ODBC data sources. You install the driver, set up a DSN, and Excel sees tables it can query. The tutorials cover the practical parts: the connection settings that trip people up, parameterized queries, joins, and keeping a report refreshable.

Microsoft Excel tutorials by data source

Don't see your data source or tool?

CData connects hundreds of sources to the tools you already use. Browse the connectors, or talk to us about a specific setup.