dts Foxpro MEMO Field

16 Sep 2005 5:01 PM

SQLbeginner

how can I import memo field from Foxpro table??

Many Thanks in Advance!!

16 Sep 2005 5:34 PM

Trey Walpole

You can transform it to a large varchar() column or a text column.
Which of these to use would depend on the average and max lengths of the
memo field.

* in vfp
select max(len(theMemoField)) as max_len from theTable

If' the max length is over 8000, you'll have to use text. If it's <=8000
_and you can say with assurance_ that the max length will stay <=8000,
I'd tend to go with a large varchar column.

SQLbeginner wrote:

Show quote

>how can I import memo field from Foxpro table??
>
>Many Thanks in Advance!!
>
>

16 Sep 2005 8:40 PM

SQLbeginner

Thanks Trey.

Show quote

"Trey Walpole" wrote:

> You can transform it to a large varchar() column or a text column.
> Which of these to use would depend on the average and max lengths of the
> memo field.
>
> * in vfp
> select max(len(theMemoField)) as max_len from theTable
>
> If' the max length is over 8000, you'll have to use text. If it's <=8000
> _and you can say with assurance_ that the max length will stay <=8000,
> I'd tend to go with a large varchar column.
>
>
>
> SQLbeginner wrote:
>
> >how can I import memo field from Foxpro table??
> >
> >Many Thanks in Advance!!
> >
> >
>

19 Sep 2005 1:09 PM

SQLbeginner

Thanks very much for the helps

Show quote

"SQLbeginner" wrote:

> how can I import memo field from Foxpro table??
>
> Many Thanks in Advance!!

20 Sep 2005 5:45 PM

SQLbeginner

I was able to import the MEMO field using the Foxpro ODBC driver, however,
not all information from the memo fields are imported. For example, a record
has 11 lines of information, it would only import part of it and some records
didn't even get any information transferred. On the SQL database table, I
use 'text' as the data type.

Does anyone has a solution?

Many Thanks in Advance.
Nancy

Show quote

"SQLbeginner" wrote:

> how can I import memo field from Foxpro table??
>
> Many Thanks in Advance!!