Inserting Access Memo Problem

Inserting Access Memo Problem

Post by Rixon Ree » Sat, 26 Feb 2000 04:00:00

We we try to insert an Access table into a linked SQL Server table, the
Access memo column is truncated after 255 characters. The SQL table has the
Access column changed from a memo to a datatype of  ntext, Length 16,
Precision 0, Scale 0. What are we doing wrong? TIA.

1. Error while inserting memo datatype in Access

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,
 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

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

SO how do i resolve this ?

2. could this restore correctly?

3. JDBC Inserts into Access 97 Memo Field

4. Not log to transaction log

5. Using ADO Command object and Access PROCEDURE to insert Memo/Binary fields

6. Performance counters missing

7. (Access 2k) INSERT SQL with memo fails..

8. Anyone tried/using EMPRESS?


10. insert/update problems with memo fields

11. Problem importing Access memo fields

12. transfer MS Access memo filed to MS SQL 7.0 problem

13. Problems with Memo-columns in Access