insert/update data in foxpro table field having datatype MEMO using linked server

Kunal Desale

Hi,

How to insert/update data in foxpro table field having datatype MEMO using Linked Server?

I have written sql insert queries in which i have used linked server to insert data into foxpro tables. Some fields have datatype Memo and in these fields my data is not getting inserted/updated.

My queries contains local tables & dbf tables (Both).

I try simple insert query which insert data into one memo field in foxpro editor
and sql editor.

It is getting inserted when execute directly on fox pro but not getting inserted/updated from sql server (using linked server)

So How to resolve this problem?

Nov 26 '08 #1

ck9663

What value are you trying to insert to?

Will http://blogs.msdn.com/sqlcat/archive/2008/01/25/foxpro-to-sql-server-migration-experience.aspx help?

-- CK

Nov 27 '08 #2

Kunal Desale

I trying to insert simple text data in field having datatype MEMO.

eg.

insert into nr...sm_srvrq(reqdesc) values('abc')

nr = linked server name
sm_srvrq = foxpro table (.dbf)
reqdesc = field having type memo
'abc' = simple text data

Nov 27 '08 #3

Kunal Desale

Hi CK

I need your help reagrding insert/udate issue of data in foxpro table memo field.
I didn't get any help from link posted by you.

Please try to send solution as early as possible.
I have added detail description already.

-Kunal

Nov 28 '08 #4