Philippe, Try this: Gateway Choose Export Select table: Viewname or tablename Select format: Use Export Wizard
In the Export Wizard you are able to define the settings per field. Save these settings in the specification filename. Then have a look in the Help Gateway Export Excel Workbook The 'specification file name' refers to the file above. Looking at your selection it might be necessary to create a (temp) view on beforehand Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Philippe Gosselin Sent: donderdag 29 oktober 2015 4:38 To: [email protected] Subject: [RBASE-L] - Excel Export Hi, Id 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:[email protected]> [email protected] 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
