Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Exporting memo fields to Excel
Message
De
14/11/2000 17:11:37
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00441850
Message ID:
00441871
Vues:
17
Hi Michael,

If you don't want to use Excel Automation you could try a method that I sometimes use. It's not ideal but it's better than nothing <s>. It involves stripping out 254 character blocks of the Memo.
SELECT PADR(SUBSTR(calls.summary,1,254),254)    AS summary1  ;
     , PADR(SUBSTR(calls.summary,255,254),254)  AS summary2  ;
     , PADR(SUBSTR(calls.summary,509,254),254)  AS summary3  ;
     , PADR(SUBSTR(calls.summary,763,254),254)  AS summary4  ;
     , PADR(SUBSTR(calls.summary,1017,254),254) AS summary5  ;
     , PADR(SUBSTR(calls.summary,1271,254),254) AS summary6  ;
     , PADR(SUBSTR(calls.summary,1525,254),254) AS summary7  ;
     , PADR(SUBSTR(calls.summary,1779,254),254) AS summary8  ;
     , PADR(SUBSTR(calls.summary,2033,254),254) AS summary9  ;
     , PADR(SUBSTR(calls.summary,2287,254),254) AS summary10 ;
FROM calls ;
INTO CURSOR calls_cursor

SELECT call_cursor
COPY TO myexcelfile XLS
Hope this Helps,
Gavin...

>Is there an easy way to do this w/o using automation with Excel?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform