Microsoft Excel connections to SQL databases – Part II: “Calculations”
In my last blog, we discussed creating, refreshing, and updating a Connection to a SQL database from Microsoft Excel. In this blog, I wanted to
January 26, 2017
Tag: Connections
Microsoft Excel Connections to SQL databases
Microsoft Excel can be a powerful tool to evaluate SQL data. In Excel, a connection can be created to directly link to a particular database
January 18, 2017
Connections between Dynamics GP and Excel
Dynamics GP interfaces with Excel in several different ways. The most common ways are through built in functions like Smartlists, Excel Budgets, and Dynamics pre-defined Excel reports. These are the base interfaces, but there are also several other methods to link GP data to Excel. Some of the other ways are through an ODBC driver, a third party add-ons, an Excel connection, etc. In this article, we will discuss the base methods as well as the Excel connection, as these are the quickest ways to get linked.
November 19, 2015
