bergsprekken
asked on
access report in excel
I import data from odbc into excel. I want to start the access report from a macro button in excel. Is this possible? Without access itself being started..
Im using microsoft query to always keep the data in my excel sheet updated. But I need to show this data like a concatenated list, like you can do with reports in access.
Or, if theres a way of grouping and showing the data like a report in excel I guess that would be the best.?
Im using microsoft query to always keep the data in my excel sheet updated. But I need to show this data like a concatenated list, like you can do with reports in access.
Or, if theres a way of grouping and showing the data like a report in excel I guess that would be the best.?
Reffer to: http://www.excelreports.info/
ASKER
What I meant to ask was how to start a access report from excel and use the data in excel.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Easiest way to accomplish this is to go to the developer tab and start recording a macro. Then manually perform an update query and stop recording. You can then find the recorded macro code by opening the VBA code editor and looking in the modules section of the spreadsheet.
In the spreadsheet itself you can add an Active-X button (click on developers tab - insert - activex - button, draw the button on the worksheet). Double-click on the button to generate the appropriate event handler and fill in the name of the recorded macro.