CData Software - Knowledge Base



Recent Excel Articles

Video: Connecting to Google BigQuery Data from Microsoft Excel

This video shows how to use the CData ODBC Driver for Google BigQuery to connect to Google BigQuery. You will create a DSN and then use the Data Connection Wizard in Excel to retrieve BigQuery data.

Video: Connecting with MongoDB Data from Microsoft Excel

This video shows how to use the CData ODBC Driver for MongoDB to connect to MongoDB. You will create a DSN and then use the Data Connection Wizard in Excel to retrieve MongoDB data.

Working with Redis Data in Microsoft Excel and Tableau

An in-depth article walking through the installation and set up of the CData ODBC Driver for Redis and using the ODBC Driver from MS Excel and Tableau.

Excel Spreadsheet Automation with the CDATAQUERY Formula

The CData Excel Add-In provides formulas that can pull data from different data sources into your spreadsheet. For example, the Google provider can create a spreadsheet of directions. In this article we show how to use the CDATAQUERY formula to automate spreadsheets.

Install a Microsoft Excel Add-In Manually

Some Microsoft Excel users may need to follow these steps to manually add the CData Excel Add-In formulas, enabling you to execute your own database queries.

Start and Stop Windows Services Using the CData Excel Add-In for PowerShell

Share and organize scripts, start and stop services, and create system reports from within Excel.

Insert Invoices with the Excel Add-In for QuickBooks

The CData Excel Add-In for QuickBooks can be used to easily retrieve and insert QuickBooks data. In this article, you will insert an Invoice into QuickBooks.

Bill an Invoice with the CData Excel Add-In for QuickBooks

The CData Excel Add-In for QuickBooks makes it easy to transfer data in and out of QuickBooks Desktop and QuickBooks Online. In this article, you will create an Invoice spreadsheet that can be sent to customers. Customers can then insert the Invoice data as Bills to their company files or their company on QuickBooks Online.

Update Multiple Invoices using the CData Excel Add-In for QuickBooks

The CData Excel Add-In for QuickBooks makes it easy to modify your QuickBooks data right in Excel. This article will explain how to use the CData Excel Add-In for QuickBooks to mark multiple Invoices at once for printing and e-mailing.

Transfer data from Excel to QuickBooks using the CData Excel Add-In

This article explains how to transfer data from Excel to QuickBooks using the CData Excel Add-In for QuickBooks. For this example, we will use the Customers table;however, the same process will work for any table that can be retrieved by the Excel Add-In.

Connect/Disconnect the QuickBooks Online Products

In this entry you will learn to use the CData Excel Add-In for QuickBooks Online or the CData Sync Application for QuickBooks Online to connect to or disconnect from your QuickBooks Online data.
 
 
 
Products


SOLUTIONS


Support
Purchase
Company
Subscriptions