Copying picture from Excel to Access OLE Object field

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: wisaac (wisdom_at_operamail.com)
Date: 04/19/04 

Date: 19 Apr 2004 16:48:03 -0700

What I would like to do is automate the manual process of copying an
image from an excel spread*** to the clipboard, and pasting it into
an access table with an OLE Object field.

I want to do something like

rsExcelImport.MoveFirst
For Each pic In My***.Shapes
  pic.Copy
'Paste to current record
  rsExcelImport.MoveNext
Next pic

Any advice on how I can accomplish this?

Quantcast