Get picture from Excel sheet

Newbe here… we have the challenge to upload rows of data from an Excel into a database on the web. No problem here… however in the Excel row there is a picture that needs to go with the data.

My plan is to grab the datarange of a sheet, clean it and output to a cleaned up data table. The cleaned up version I can loop through and add the records one by one into the database. Easy…

However each record set has a picture to go with it. And I can’t get my head around how to fix that.

So a typical row would look like this:

How can we make this work so the picture is kept with the record that we need to upload in the database?

Hi,

I would look to use VBA to achieve this particular problem.

You can use Invoke VBA activity

Thanks,
Tim

Many thanks, that will help me in the right direction!