Transferring access report to excel...
Posted on 2006-11-15
I have an app that records a help desk-style log into an acess database (ado).
I created a report within Access to generate the output that I want. Now, I'd like to blend that into my app.
Within access, I can simply open the report, go to Tools/Office Links/Analyze with Excel to accomplish this, but I want to do it from my code.
The reporting feature that I currently have is designed to loop through the recordset and drop the fields into Excel.
That works fine, but I need to duplicate that reporting from the Report that I've created in Access. I need the easiest solution possible since this code is quite old and I'm trying to talk myself out of doing this anyway... ;)
Let me know if anything else is needed to get started.