Inserting Access Memo Problem

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.

Top

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

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?

9. PROBLEMS INSERTING MEMO FIELDS FROM TABLE FIELD TO TEXT FILE

10. insert/update problems with memo fields