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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement