O'Reilly logo

Building Dashboards with Microsoft Dynamics GP 2016 - Second Edition by Mark Polino, Belinda Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Office Data Connection files

Excel has its own method of importing external data from a variety of sources, including data in the SQL Server. This method can be embedded directly in the workbook or stored in a separate file, the Office Data Connection (ODC) file. When this .odc file is created, it can be reused over and over for a quick connection between your GP and Excel that is refreshable.

Creating an .odc file

Let's create an .odc file to bring in our vendors using these steps:

  1. In Excel 2016, go to Data | From Other Sources | From SQL Server:
    Creating an .odc file
  2. The Data Connection window will open. Enter the name of your server and your GP log in credentials. Click ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required