Programmatically Export to Excel

  • Thread starter charles.kendricks
  • Start date
C

charles.kendricks

I have a report that is generated each month showing patient intake
and discharge dates, length of stay, and charge (length of stay
multiplied by a specific dollar amount). But for some reason my boss
wants that report in the form of an Excel spreadsheet. Is there a way
to programmatically export the base recordset to an Excel spreadsheet?
 
G

Guest

It depends on the type of report, and if you wish to create graphs...

Try this and see if it suffices your needs.

Open your report.
Then goto Tools - Office Links - Analyze with Microsoft Office Excel

If this is good enough to meet your needs then post back explaining the
issue(s) and we can try to address them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automating export to Excel 4
Access 2007 Report Formats -- Export to Excel 7
Export Access Report to Excel 4
Access Runtime 2003 Export to Excel Toolbar gone - replacement options? 1
Export Data from Queries in Access 2007 to Excel Spreadsheet 1
export email recipient addresses to excel 3
Export a DataTable to Excel 1
Export Memo Field to Excel 1

Top