>>>Hi,
>>>just looking at exportation possibilities with FoxPro. The command
>>>
>>>EXPORT TO filename TYPE XLS
>>>
>>>creates an Excell spreadsheet having one column per field but it doesn't export Memo fields at all. Is that the normal behavior? Then do we have to retreive memo fields ourself?
>>>
>>>Claude.
>>
>>Yes, it's normal behaviour. You can convert memo into character field(s) on fly:
>>Select field1,field2,left(memo1,100) as charmemo1 From ... Into Cursor tmp1
>>EXPORT to ....
>
>
>Knowing that a character field is limited to 255 char how can I export memo fields of unknown lenght?
IMHO, you could cut memo field to reasonable (from business standpoint) number of character fields.
Edward Pikman
Independent Consultant