Convert from Excel 2007 by using the adapterflow activity "Convert to Excel"

Convert from Excel 2007 by using the adapterflow activity "Convert to Excel"

​
When converting a CSV file to Excel using an AdapterFlow with the "Convert to Excel" activity, you need to ensure that the necessary Microsoft Access Database Engine Drivers are installed when working with Excel 2007.

​1. Verify Driver Installation

  1. Ensure that both Microsoft-ACE.OLEDB.16.0 and Microsoft-ACE.OLEDB.12.0 drivers are installed
  2. If one of the drivers are missing, uninstall the current driver and reinstall using the correct executable (.exe) from the provided link below.
  3. If either driver is missing, you may encounter the following error:
Warning
excelConvertTo1: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

2. Download the drivers

  1. Download and install the 32-bit version of the Microsoft Access Database Engine Drivers.
  2. The installation file can be found at: iCore Solutions - Convert to Excel