DynamicAccounting.netYou, Me, and Dynamics GP

2010-10-11 · 2010

Weekly Dynamic: Integration Manager and Excel

Development & IntegrationTips & Hidden FeaturesExcel & Office

Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

Often users save Excel files to CSV or Tab delimited files for use with Integration Manager. IM provides a way to skip the conversion and just import an Excel file. To make this work you simply need to define a range in the Excel file first. Then create a simple ODBC data source and pick the Excel driver. Select the Excel file and the range.

Now you can skip the middle man and integrate directly from Excel.