Top of my head - do the main copying then open the sheet and programmatically copy the memo fields over, via automation.
??
Terry
>Hello all,
>
>I am currently working with a free table that contains, among others types, a memo field.
>
>A new requirement has been introduced whereas the client needs the contents of this table in Excel format. I have tried, without success, to copy to filenamex type xl5. Apparently, Excel and / or VFP have difficulty with memo fields during this transition.
>
>Short of creating another table of the same structure replacing the memo field with a character field (and running the risk of data loss)and then scatter memvar memo, insert into table2 from memvar, is there another method that I could use to achieve the desired result? Ultimately, how do I get Excel to recognize VFP memo fields?
>
>TIA
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.