How to convert/copy memo field to text ?

Thread View: comp.databases.mssqlserver

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by meh Tue, 17 Feb 2004 18:19

Author: 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.

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

Author: 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.
>
>

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

Author: 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.
> >
> >
>
>

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

Author: oj
Date: Thu, 19 Feb 2004 06:36

53 lines
2606 bytes

I am afraid not.

-- 
-oj
http://www.rac4sql.net


"mac" <mac@hotmail.com> wrote in message
news:4MNYb.43806$1S1.11670@nwrddc01.gnilink.net...
> 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.
> > >
> > >
> >
> >
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads