Adding an Excel Doc

[StacyStacy]

GOAL: I want to create a form in Access whereby a User can click onto a button and obtain a report in an Excel spreadsheet from a switchboard menu. That's the easy part.

HERE'S WHAT I'VE DONE:
I have imported 2 .dbf files via an ODBC. I have created a query and as a result, created a report in Access. I exported the report into an Excel spreadsheet. That's not what I really want to do. How do I save the report generated in Access into an Excel spreadsheet and save it under the Report section in Access.

I hope I was not too confusing. Thanks.

 

[llkhoutx]

Access can't "save" a report. It must be re-run.

Data can be "slammed" to Excel into specific cells of an Excel spreadsheet which appears to be a report.

Check out "Excel Automation" in the Excel Help menu or the print pape resource of your choise. Litwin has detailed examples. There's lots of problems with doing this. You have to do some Excel VBA coding.