Microsoft Access.. Export to Excel with pictures??

[jcarson]

I have some data in a report which I need to export to excel. This will include an IMAGE.

I want to export this data to excel and have the excel sheet with all the required data, plus have it formatted like I want it with the company logo at the top etc..

Anyone know how to do this?

 

[dderolph]

I just added an image to an Access report and exported it to Excel. The image did not carry over to Excel. Is that the issue you're raising? I think the solution is to export the report and then add the image within Excel.

 

[jcarson]

Yeah, thats the issue.. Just need to add a common image per XLS created too.

I wanted to make it a one step procedure (for the office people), so I guess its not possible.

 

[dderolph]

Right, I believe a one-step procedure is not possible. You could develop a simple macro in Excel to insert the image and put a button, linked to the macro, on an Excel toolbar. Then, the image could be added by just clicking on the button. If the desired position of the image changes, either revise the macro or just drag the image to the desired position. If you don't want to use the macro technique, I think I would write a step-by-step procedure for inserting the image and give it to each user.