Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting memo fields to Excel
Message
From
14/11/2000 17:11:37
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australia
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00441850
Message ID:
00441871
Views:
20
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform