11 October 2010

Weekly Dynamic: Integration Manager and Excel

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.