Error while inserting memo datatype in Access

Error while inserting memo datatype in Access

Post by FR » Sun, 11 Nov 2001 08:58:19



Server: Msg 8626, Level 16, State 1, Line 1
Only text pointers are allowed in work tables, never text, ntext, or image
columns. The query processor produced a query plan that required a text,
ntext, or image column in a work table.

This is the query

insert tests
select lTestID,lTestSeq,ctExecutionDate,strStation,
strOperator,memoNotes
 from  OPENROWSET('Microsoft.Jet.OLEDB.4.0',
   '\\slss\d$\CS.mdb';'admin';'', tests)
   AS xyz
where not exists ( select * from tests t where t.ltestid = xyz.ltestid )

Now the memoNotes field is of datatype memo in Access and of type text in
SQL.

Currently the values in Access for that column are Null . There are only 12
rows in Access.

SO how do i resolve this ?