import excel file

[mannyy12]

Hello
Can I import comments with images from the excel file into the acess database?

[CJ_London]

What sort of images are you talking about? some text with imogies? or pictures with descriptive text? something else?. You might be able to do it with VBA but would be complicated. But not enough info to point you in the right direction

[mannyy12]

only photo posted to the comment as background

[Gicu]

Yes you can, but you will need to use OLE automation and Excel's object model, here are a couple of links that shows you how to add the picture so it should give you most of the needed objects:

https://stackoverflow.com/questions/...as-comment-vba
https://www.thespreadsheetguru.com/t...o-cell-comment

Cheers,

[mannyy12]

I don't understand, I have a vba code that uploads photos as a comment, but how do I transfer these comments to acess?
?

[Gicu]

In your Access db you need to automate Excel (open an Excel instance, load the workbook, start looping through its shapes collection, get the picture, save it, etc.).
Here is another link that might help you:

https://www.mrexcel.com/board/threads/how-to-import-export-pictures-from-excel-to-access-database.371689/

[mannyy12]

""get the picture, save it, etc.)"" how can i get the picture from comments?

[Gicu]

Mannyy12, what have you tried? As Ajax pointed out it is not easy. How comfortable are you with VBA code? The last link should have given you enough to start (the code at the bottom of the webpage).
Cheers,