Era mesmo isto que faltava para trabalhar as bases de dados, que cada vez mais me aparecem. Alguma pesquisa lá deu fruto.
To change the default on your PC to a pipe rather than a comma bring up your default options window by clicking Start -> Settings -> Control Panel -> Regional Settings.
Click the “Number” tab and in the “List Separator” field, replace the current default separator with the one you want to use (let’s say a pipe symbol | ).
Click “OK” to save the change and close the window. You can now save Excel files as pipe delimited files by simply doing the following in Excel: