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

Article View: comp.databases.mssqlserver

Article #2

Back to comp.databases.mssqlserver Previous Next

From: oj
Date: Tue, 17 Feb 2004 22:45

27 lines
1778 bytes

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: <eXpTKfa9DHA.2752@TK2MSFTNGP09.phx.gbl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!cyclone.bc.net!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl

References: <4XsYb.19148$5W3.6763@nwrddc02.gnilink.net>

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-17 14:47:00 PST
From: "oj" <nospam_ojngo@home.com>
References: <4XsYb.19148$5W3.6763@nwrddc02.gnilink.net>
Subject: Re: How to convert/copy memo field to text ?
Date: Tue, 17 Feb 2004 14:45:47 -0800
Lines: 29
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.1165
Message-ID: <eXpTKfa9DHA.2752@TK2MSFTNGP09.phx.gbl>
Newsgroups: comp.databases.mssqlserver,cz.comp.microsoft.sql,microsoft.public.sqlserver.programming
NNTP-Posting-Host: fw.pdx.polyserve.com 216.64.170.67
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!cyclone.bc.net!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl

Reply to Parent Message