CData Software - Knowledge Base

Show articles by: Integration Technology | Driver Technology | Recent Articles

Recent Excel Articles

«
1
2
3
4
5
6
7
8
9
10
»

Transfer Company File Data using the CData Excel Add-In

This article shows how to use the CData Excel Add-In for QuickBooks to transfer data from one company file to another. You will use the Excel Add-In to manage multiple connections and transfer customer records from one company file to another.

Access SAP Tables and SAP Queries using CData SAP Providers

In this article we explain how our SAP products obtain table information and provide a free helper utility to add additional table schemas to our SAP Providers.

Excel Files as Data Sources Using CData ADO.NET Providers

Bjoern Meyer from Text Control explores using the CData Data Providers with TX Text Control Words, the Text Control Reporting template designer.

Import Salesforce Data into Microsoft Power Query

The CData API Server offers standards-based web service endpoints that allow a variety of applications to get data from Salesforce. These endpoints expose data as OData, RSS, HTML, CSV, ATOM, SOAP, JSON, JSONP, and TSV. In this article, we will use the CSV format to import Salesforce data into Microsoft Power Query.

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 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.

«
1
2
3
4
5
6
7
8
9
10
»