Devart Blog

ODBC

How to import data to Excel using ODBC

Posted by on December 6th, 2016

In this article, we will discuss how to access data using ODBC driver in Microsoft Excel. We will examine in detail the data retrieving process.
Cloud technologies develop rapidly, more and more data is stored in the cloud. Microsoft provides a great number of tools for data management and for cloud-stored data in particular. Microsoft Excel is one of the most popular products for data management. However, it works locally on a user’s machine. Is there any chance to access data in the cloud? The answer is yes. Here ODBC comes into the action. Let’s see how to use ODBC driver for NetSuite as a connectivity solution between NetSuite ERP and MS Excel.
(more…)

Installation & Configuration of Devart ODBC Driver for QuickBooks

Posted by on August 3rd, 2016

The article describes installation and configuration of Devart ODBC Driver for QuickBooks on Windows, as well as authorization and connection to a QuickBooks account, and provides a demo sample of retrieving QuickBooks account data using Microsoft SQL Server Management Studio.

(more…)