Automation Action: Insert CSV into XLS File (97 - 2003)
Inserts CSV data into a 97 - 2003 XLS sheet.
Requires a file to have already been created, and the worksheet name to be provided where the CSV will be inserted.
- A new header row will be created at the top of the worksheet or where data first occurs within the sheet.
- If data is present within the first row, it will be overwritten. It is recommended to reserve the first row for headers and within cell A1 enter a placeholder value.
- Having the XLS file open within another program at the same time may cause errors.
This custom action requires the "Microsoft.ACE.OLEDB.12.0" driver to function. This can be downloaded here