BAM Definition XML Exporter (ExportBamDefinitionXml.exe)

The BAM Definition XML Exporter (ExportBamDefinitionXml.exe) is a tool that exports the XML definition of a BAM model from inside an Excel workbook to an XML file. The XML file, which is always present inside a BAM workbook, may be used as input to the BizTalk BAM Utility (bm.exe) in order to deploy or manage a BAM model without having Microsoft Excel installed -- typical for a BizTalk server.

ExportBamDefinitionXml <ExcelFile> <XMLFile> [UseLegacyExport]

Arguments

Argument	Description
ExcelFile	The path to a BAM Excel workbook file (.xls)
XMLFile	The path to an XML file that will contain the exported XML data
UseLegacyExport	An optional (and rarely necessary) option that tells the tool to use Excel Automation, which requires Excel to be installed. This option should be used only as a last resort if exports are not working for a problematic workbook. To activate this option, pass the value "True" (without the quotes).

Remarks

Working with Excel 2003 files requires the Microsoft JET 4.0 OLE DB driver, which is typically present on machines that have the .NET Framework 2.0 or newer installed.

Working with Excel 2007 or newer files requires the Microsoft Office 2007 Data Connectivity Components or Access Database Engine 2010 Redistributable, both of which can be obtained from Microsoft.com’s Download Center. If you’re working on a machine that has Excel 2007 or 2010 installed, the components are already present (usually the case for a development machine).

It is not currently possible to install both the 32-bit and 64-bit versions of certain data access components, including the Access Database Engine 2010 Redistributable. As a result, if you have the 64-bit data access components installed (or 64-bit Office), then this tool must also run as 64-bit, and likewise for 32-bit. The Deployment Framework for BizTalk includes only the 32-bit version of the tool, so please install the 32-bit version of data access components.