How to convert/copy memo field to text ?

Article View: comp.databases.mssqlserver

Article #1

Back to comp.databases.mssqlserver Previous Next

From: meh
Date: Tue, 17 Feb 2004 18:19

14 lines
1674 bytes

I have database in SQL2K and program in VFP.
My select statement is


SELECT PARTNO, DESC, QTY, PRICE

I save above selection into cursor.   DESC is a memo field.  I want to use
this selection and copy to excel file.
All other fields are copying except DESC and that is memo field.

How can I copy/convert DESC field to text while selecting records so I can
import into excel file ?

Thanks.

Technical Details

Message-ID: <4XsYb.19148$5W3.6763@nwrddc02.gnilink.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!zeus.visi.com!news-out.visi.com!petbe.visi.com!news.octanews.net!newsfeed.news2me.com!cyclone1.gnilink.net!spamkiller.gnilink.net!nwrddc02.gnilink.net.POSTED!53ab2750!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 102fb4,5c27fac3556db4f3,start
X-Google-Attributes: gid102fb4,public
X-Google-Thread: ff490,5c27fac3556db4f3,start
X-Google-Attributes: gidff490,public
X-Google-Thread: 11301e,5c27fac3556db4f3,start
X-Google-Attributes: gid11301e,public
X-Google-ArrivalTime: 2004-02-17 10:19:45 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!zeus.visi.com!news-out.visi.com!petbe.visi.com!news.octanews.net!newsfeed.news2me.com!cyclone1.gnilink.net!spamkiller.gnilink.net!nwrddc02.gnilink.net.POSTED!53ab2750!not-for-mail
From: "meh" <mac@hotmail.com>
Newsgroups: comp.databases.mssqlserver,cz.comp.microsoft.sql,microsoft.public.sqlserver.programming
Subject: How to convert/copy memo field to text ?
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <4XsYb.19148$5W3.6763@nwrddc02.gnilink.net>
Date: Tue, 17 Feb 2004 18:19:44 GMT
NNTP-Posting-Host: 66.13.113.18
X-Complaints-To: abuse@verizon.net
X-Trace: nwrddc02.gnilink.net 1077041984 66.13.113.18 (Tue, 17 Feb 2004 13:19:44 EST)
NNTP-Posting-Date: Tue, 17 Feb 2004 13:19:44 EST