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