[RBASE-L] - Excel Export

[Philippe Gosselin]

Hi,

 

I’d like to export a note column in an excel spreadsheet. The lines in the
column are separated by a (char(13)). When I export to Excel, I get a cell
with all the lines joined together (1 long line instead of several different
lines).

 

I use the command below where description is the note column

SELECT
t2.fa_intitule,t4.titre,t3.ar_prixven,0,0,t4.description,t4.marque1,DISTINCT
t1.ar_ref,'En stock',' ',' ',' ',' ',1,' ' +

FROM f_artstock t1,f_famille t2,f_article t3,etiq_pres t4 +

WHERE t1.de_no IN (1,3,126,4,183,201,5) AND t1.as_qtesto > 0 AND t1.ar_ref =
t3.ar_ref AND t1.ar_ref = t4.codeart AND t3.fa_codefamille =
t2.fa_codefamille AND t1.ar_ref LIKE 'EHDIVT%'

 

Is the a way to export “description” so that the cell in excel show the
lines separated?

 

Thanks,

 

Philippe

 <mailto:p...@canl.nc> p...@canl.nc



8, rue Jean Jaures - BP 3899 - 98846 Noumea – New Caledonia

Tél : +687 27.62.23 / Fax : +687 27.30.73 / Mobile : +687 77.15.76