Re: How to convert/copy memo field to text ?

Article View: comp.databases.mssqlserver

Article #3

Back to comp.databases.mssqlserver Previous Next

From: mac
Date: Wed, 18 Feb 2004 18:01

42 lines
2490 bytes

Thanks for your reply.

Ok, suppose I have a select statement and am selecting desc which is memo
field, can I use do while in the select statement in SQL2K to read all the
lines in the memo field to a text variable ?

Thanks.


"oj" <nospam_ojngo@home.com> wrote in message
news:eXpTKfa9DHA.2752@TK2MSFTNGP09.phx.gbl...
> It would be a multi step process. You read the data into a stream and
> bulkload it into sqlserver database. AFAIK, there isn't a direct way to
> convert VFP memo type to SQL text type.
>
> --
> -oj
> http://www.rac4sql.net
>
>
> "meh" <mac@hotmail.com> wrote in message
> news:4XsYb.19148$5W3.6763@nwrddc02.gnilink.net...
> > 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: <4MNYb.43806$1S1.11670@nwrddc01.gnilink.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!crtntx1-snh1.gtei.net!news.gtei.net!newsfeed1.easynews.com!easynews.com!easynews!cyclone1.gnilink.net!spamkiller.gnilink.net!nwrddc01.gnilink.net.POSTED!53ab2750!not-for-mail

References: <4XsYb.19148$5W3.6763@nwrddc02.gnilink.net> <eXpTKfa9DHA.2752@TK2MSFTNGP09.phx.gbl>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 102fb4,5c27fac3556db4f3
X-Google-Attributes: gid102fb4,public
X-Google-Thread: ff490,5c27fac3556db4f3
X-Google-Attributes: gidff490,public
X-Google-Thread: 11301e,5c27fac3556db4f3
X-Google-Attributes: gid11301e,public
X-Google-ArrivalTime: 2004-02-18 10:01:37 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!crtntx1-snh1.gtei.net!news.gtei.net!newsfeed1.easynews.com!easynews.com!easynews!cyclone1.gnilink.net!spamkiller.gnilink.net!nwrddc01.gnilink.net.POSTED!53ab2750!not-for-mail
From: "mac" <mac@hotmail.com>
Newsgroups: comp.databases.mssqlserver,cz.comp.microsoft.sql,microsoft.public.sqlserver.programming
References: <4XsYb.19148$5W3.6763@nwrddc02.gnilink.net> <eXpTKfa9DHA.2752@TK2MSFTNGP09.phx.gbl>
Subject: Re: How to convert/copy memo field to text ?
Lines: 44
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: <4MNYb.43806$1S1.11670@nwrddc01.gnilink.net>
Date: Wed, 18 Feb 2004 18:01:36 GMT
NNTP-Posting-Host: 66.13.113.18
X-Complaints-To: abuse@verizon.net
X-Trace: nwrddc01.gnilink.net 1077127296 66.13.113.18 (Wed, 18 Feb 2004 13:01:36 EST)
NNTP-Posting-Date: Wed, 18 Feb 2004 13:01:36 EST

Reply to Parent Message