Export Memo Field to Excel 2

[wsjames]

I have a table with a memo field. I would like to convert the table to an XLS format. When using the 'Export To' or 'Copy To' commands, all fields except the memo field is converted. Upon opening the new table from within Excel, I see that the memo field is not included. Is there a way to import a memo field (inclusive with other fields) into Excel using FP or VFP? I am currently using FP2.6 and have made attempts with VFP as well.

 

[JRB-Bldr]

"Is there a way to import a memo field (inclusive with other fields) into Excel using FP or VFP?"

Not directly.

But you could make a copy of your table into a new table which contained a new, additional text field and then export that new table to Excel.

SELECT *,;
  SPACE(128) as TextMemo;
  FROM MyTable;
  INTO TABLE ExpDBF

SELECT ExpDBF
* -- Put Memo Data Into New Character Field ---
REPLACE ALL TextMemo WITH Memo

* --- Copy This To Excel ---
COPY TO MyWkSht.xls XLS

* --- Erase Temporary Table Files ---
ERASE ExpDBF.dbf
ERASE ExpDBF.fpt

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[TheRambler]

Another alternative would be to export to a text file, and then open the text file with Excel.
See How to export memo fields with other field types to a text file with Visual FoxPro.

 

[wsjames]

To TheRambler & jrbbldr:

Thank you. I have 2 workable solutions. I'll be sure to donate and tell others of Tek-Tips and your expertise.

You're awesome.