Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting fields to Excel
Message
 
To
12/10/2001 11:04:26
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00567625
Message ID:
00567652
Views:
8
Try to transform memofield to char type, like:

select left(memofield,255)...
copy to .. XLS

Seems Excel has 255 limit on the string length in the cell. Check Excel Help for details.



>Hi,
>
>I have a dbf that contains 6 char fields and 2 memo fields. This dbf represents a call logging system. The char fields represent the customer's details and the memo fields represent the problem and solution details.
>
>When I try to export the fields over to Excel I cannot get the memo fields to export. I need to do this so I can report on the call logging.
>
>Does anyone have a solution to my problem?
>
>Thanks to all who reply.
>
>Jason
Previous
Reply
Map
View

Click here to load this message in the networking platform