dbTalk Databases Forums  

append of text from MS Access to binary datatype in SQL Server not displaying

comp.databases.ms-access comp.databases.ms-access


Discuss append of text from MS Access to binary datatype in SQL Server not displaying in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tony_E
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.