Insert Row of Data with Pictures to Access

[daffodil11]

I am trying to push x rows of data from a worksheet to an Access database, with three of the ten cells going to a respective attachment field in the DB.
The Pictures within these cells might, or might not exist, and they are tiny thumbnails 10-50k. I receive a new workbook weekly from an external data manager.

I'm not particularly great at VB within Access, so I'm looking for what type of approach I should take.

Here's the first outline I've thrown together, which considers one row at a time, cycles through the pictures, and saves and adds them:

Please Login or Register  to view this content.

My other idea would be to simply transfer/insert/add the rows to the existing table in Access in a single action, and then go through the export of all shapes while saving them with identifiers. And then pull specific records from the DB and add the saved images to the empty attachment fields.

I'm just unclear on how to properly add to a table of records, retrieve specific records if I opt for method #2, or event programatically insert attachments.

Thoughts?

[daffodil11]

Failing a method to programtically add attachments to the database, I instead opted to use the SaveAll Shapes loop to replace all pictures with filepaths of the images stored on a network share, and then append the entire worksheet directly to the database.

With the filepaths in text fields, reports and forms are now generating to Picture Controls which correctly display the images I needed.