急 高手进 IMAGE字段追加数据

Question

--更新text字段的值
create table PE_Soft(SoftIntro text,ChannelID integer) 
insert into PE_Soft 
select  'aaa ',1004 
union all 
select  'bbb ',1003 
union all 
select  'ccc ',1002 declare @ptr binary(16) 
select @ptr=textptr(SoftIntro) from PE_Soft where ChannelID=1002 
updatetext PE_Soft.SoftIntro @ptr null 0  'testing ' 
select * from PE_Soft drop table PE_Soft/*
SoftIntro                                                                                                                                                                                                                                                        ChannelID   
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- 
aaa                                                                                                                                                                                                                                                              1004
bbb                                                                                                                                                                                                                                                              1003
ccc testing                                                                                                                                                                                                                                                      1002（所影响的行数为 3 行）*/

Answer 1

谢谢你
你的办法在ACCESS中好像不行
有没有在ACCESS中可以实现的办法

Answer 2

create table PE_Soft(SoftIntro IMAGE ) 
insert into PE_Soft 
select  '011111001011001100001100'declare @ptr binary(16) 
select @ptr=textptr(SoftIntro) from PE_Soft 
updatetext PE_Soft.SoftIntro @ptr null 0  '10000000000000000011' 
select * from PE_Soft drop table PE_Soft

Answer 3

可以出引EXCEL批量加完后再引入吗