Weekly Review: Integration Manager and Excel

Development & Integration Tips & Hidden Features Excel & Office

Archived post from 2012. 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.

Posted by Mark Polino at 10/11/2010 09:00:00 AM

Original article: http://msdynamicsgp.blogspot.com/2010/10/weekly-dynamic-integration-manager-and.html