# Weekly Review: Integration Manager and Excel

- URL: https://dynamicaccounting.net/weekly-review-integration-manager-and-excel/
- Date: 2012-07-05
- Topics: Development & Integration, Tips & Hidden Features, Excel & Office
- Type: link to an external article
- Source: http://msdynamicsgp.blogspot.com/2010/10/weekly-dynamic-integration-manager-and.html

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](http://msdynamicsgp.blogspot.com/2010/10/weekly-dynamic-integration-manager-and.html "permanent link")