Open filename For Binary As #1
LFileSize = LOF(1) - 1
Dim Bdata(LFileSize) As Byte
Get #1, , Bdata
Close #1
Adodc1.Recordset.Fields(i).AppendChunk Bdata
LFileSize = LOF(1) - 1
Dim Bdata(LFileSize) As Byte
Get #1, , Bdata
Close #1
Adodc1.Recordset.Fields(i).AppendChunk Bdata
Dim Buffer() As Byte
flen = FileLen("E:\csdn\Data\user2.gif")
Open "E:\csdn\Data\user2.gif" For Binary As #1
ReDim Buffer(flen - 1)
Get #1, , Buffer
adoPrimaryRS.Fields("photo").AppendChunk (Buffer)
adoPrimaryRS.UpdateBatch adAffectAll