• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

append to immage field type in sqlserver 2005

we are on sqlserver 2005

we want to 'append' data to a field that is 'image' reports ole object in ms access

Used to use a function 'str2raw' to perform this but it doesn't work anymore PLEASE help.
0
MyDanes
Asked:
MyDanes
  • 2
1 Solution
 
David ToddSenior DBACommented:
Hi,

What is the type in SQL?

What are you storing in this field?

SQL 2005 has some new types that are better for blobs than image and memo.

Cheers
  David
0
 
MyDanesAuthor Commented:
use [ITWT]
insert into part_binary (PART_ID, TYPE, BITS, BITS_LENGTH)

SELECT PART_ID, TYPE, cast(cast(BITS as varchar (8000)) as image), len(cast(BITS as varchar (8000)))

FROM  OPENDATASOURCE(

 'Microsoft.Jet.OLEDB.4.0',

 'Data Source="g:\visual\itw\itw.mdb";

 User ID=Admin;Password='

 )...PART_BINARY

where PART_ID IN

(SELECT ID FROM PART)

0
 
MyDanesAuthor Commented:
Thanks for responding below your comment is exactly what I ran to resolve.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now