Option ExplicitPrivate Sub Command1_Click() Dim rs As New ADODB.Recordset Dim photo() As Byte Open "C:\aa.bmp" For Binary Access Read As #1 photo = InputB(LOF(1), #1) Close #1
rs.Open "select * from tablename", cn, adOpenDynamic, adLockPessimistic rs.AddNew rs!photo.AppendChunk (photo) rs.Update End Sub
http://support.microsoft.com/default.aspx?scid=kb;EN-US;258038
Dim rs As New ADODB.Recordset
Dim photo() As Byte Open "C:\aa.bmp" For Binary Access Read As #1
photo = InputB(LOF(1), #1)
Close #1
rs.Open "select * from tablename", cn, adOpenDynamic, adLockPessimistic rs.AddNew
rs!photo.AppendChunk (photo)
rs.Update
End Sub