OLE Object Field Copy to another Access Table

Hi,

I have the following code to copy fields into another Access Database Table. I am having hard time to copy teh OLE Object field which contains image information.

MySqlText = "INSERT INTO BackupTable (OriginalID, Image1) VALUES(" & de1.rsOriginal("ID") & ", '" & de1.rsOriginal("Image1") & "');"

Image field is the OLE Object field

Could anyone tell me how to copy OLE Object fields from one table to another?

Thanks

Hi, I have the same problem. Did you find a solution for this?
Regards, Paul.

Really? 11 years later? Please don't revive old posts.

Quote:

---

Originally Posted by dglienna

Really? 11 years later? Please don't revive old posts.

---

Well, apparently no-one had a solution for this, so it is not a trivial question. As you're an (ex)MVP, it must be very simple to answer this question instead of reacting like this...

Sorry, only now I see you include some links. Thanx, I will study them!