1. Create a CSV connection (the delimiter character and whether the first row has column info can be specified)
2. Once connected, go to the Object explorer and highlight the required text file (you may see other txt and csv files that exist in the folder. This is
as designed (see additional information below)
3. Right Click the file | Select Export Wizard - run through the wizard to export to your required Excel output file.
4. Save as a template
5. In automation select 'Export Wizard' and use the template that has just been created.