OLE Object Field Copy to another Access Table

**LeoKoach** · July 27th, 2003, 09:33 AM

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

**paulwise3** · March 9th, 2013, 04:52 AM

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

**dglienna** · March 9th, 2013, 01:32 PM

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

**paulwise3** · March 9th, 2013, 03:09 PM

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...