469,622 Members | 2,120 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,622 developers. It's quick & easy.

Copying a picture from excel to Access

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?
Nov 12 '05 #1
2 3725
wi****@operamail.com (wisaac) wrote in message news:<db**************************@posting.google. com>...
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?


I'm not having much luck with this so far. I have an excel
spreadsheet with several pictures in it. I want to copy these
pictures to an MS Access table with an OLE Object field. If I can
copy and paste it in with a VBA script, that would be ideal, but if
there's another way to do it, please let me know.
Nov 12 '05 #2
wi****@operamail.com (wisaac) wrote in message news:<db**************************@posting.google. com>...
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?


I'm not having much luck with this so far. I have an excel
spreadsheet with several pictures in it. I want to copy these
pictures to an MS Access table with an OLE Object field. If I can
copy and paste it in with a VBA script, that would be ideal, but if
there's another way to do it, please let me know.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by ColinWard | last post: by
reply views Thread by mjwoods_2002 | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.