1. Selecting data from the database INGRES

    # fichier export.sql:
    Select '@~@nom@~@','@~@ville@~@';
    Select '@~@'+nom+'@~@','@~@'+ville+'@~@' FROM addr;

  2. Creating comma delimited file (csv) on UNIX

    # select data and write csv file
    sqlexp < /export.sql | sed "s/\"/\"\"/g" | sed "s/@\~@/\"/g" > /addr.csv

    # fichier addr.csv
    "nom","ville"
    "Dupont","Paris"

  3. Converting comma delimited file (csv) to Excel format with csv2xls on UNIX

    # convert to Excel
    csv2xls /exh.csv /addr.xls