I'm currently extracting data from Access forms into an excel file. The data contains multiple characteristic fields such as Name, Age, Address, etc. organized in a way that I would like to duplicate in excel. I know how to use the extracting tool which brings up all of the data (not just individual form data) into a giant table in excel. Currently, I am manually splitting up the data and creating separate sheets which then requires formatting to make it presentable in the format I want. I am wondering if I can set up an Access macro or function that will export the data in an object to specific cells on an excel sheet. Also, the forms include a picture of the person and I've been requested to include the picture in excel. Is there anyway to include a picture when exporting data from Access to Excel?
Any help would be great,
Thanks