Copying a picture from excel to an Access OLE Field

W

wisaac

What I would like to do is automate the manual process of copying an
image from an excel spreadsheet 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 MySheet.Shapes
pic.Copy
'Paste to current record
rsExcelImport.MoveNext
Next pic

Any advice on how I can accomplish this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying images from Excel to Access 4
Merging from an Excel file with graphics 1
Excel hart has OLE onject errors in Access 2007 0
OLE object from table to Word. 0
Linking data in MS Word into Excel 5
Using Access Database to build contracts with fields on pdf document 0
use VB to store data in OLE field 2
Extracting OLE data in "Picture" or "Microsoft Word Picture" format 0

Top