append of text from MS Access to binary datatype in SQL Server not displaying -
03-29-2011
, 03:22 PM
Hello;
Access 2000
We append an access table to a sql server table through a linked ODBC
connection in access. The append succeeds. One of the fields in the
access table is text. In the append to the sql server table it mates
to a binary field (in access it reads OLE). The text data does not
display in the app window that points to this field. (This app window
is part of an ERP app).
Any ideas or suggestions as what is going on? Why it won't display?
Thanks
Tony |