CData Software - Knowledge Base



Recent Excel Articles

Automated Continuous Excel Online Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Excel Online replication to delimited files (CSV/TSV).

Transfer Data from Excel to Avro

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

Import and Visualize QuickBooks POS in Power View

Create data visualizations based on QuickBooks Point of Sale in Excel.

Use the CData ODBC Driver for Amazon DynamoDB in Microsoft Power Query

You can use the CData Amazon DynamoDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Amazon DynamoDB into Microsoft Power Query.

Transfer Data from Excel to FTP

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

Configure a One-Way Send Port for the CData BizTalk Adapter for Excel

Use the adapter for Excel with a one-way send port to execute updategrams and data manipulation SQL in BizTalk.

Use the CData ODBC Driver for WooCommerce in Microsoft Power Query

You can use the CData WooCommerce ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import WooCommerce into Microsoft Power Query.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Work with Shopify in MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData Software ODBC Driver for Shopify and work with Shopify in Microsoft Excel on Mac OS X.

Import and Visualize NetSuite in Power View

Create data visualizations based on NetSuite CRM & ERP in Excel.

Use the CData ODBC Driver for Sage 50 UK in Microsoft Power Query

You can use the CData Sage 50 UK ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sage 50 UK into Microsoft Power Query.