Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export table with memo field to Excel
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00957691
Message ID:
00957716
Views:
42
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform