Export access reports data into excel sheets

  • Thread starter Thread starter Praveen
  • Start date Start date
P

Praveen

Hi,

I have some Access reports and I want to export those reports (data ) into
Excel. Is this possible?
I have researched on this, and I figured how to export the data in the table
to the excel but not the data in the report. Could you guys, please help me
on this?
 
Hi,

I have a small correction. If we right click on the report and select
"export", we can export that the report data to excel.
But what I mean is, if the users don't have the permission to directly view
the reports (they can only launch the report from other forms),
how can they export that report data to excel?


Thanks
Praveen Manne
 
The RecordSources of the Reports can be a Table, a Query or an SQL String.
Use the RecordSources (rather than the Reports) as the Source for your
exports to Excel.
 
I think you can just click on the report (not open it, just select it) and
use Tools, Office Links, Excel. But I think you would get a cleaner result
if you export the underlying query to Excel and then format your report in
Excel. If you rather export the report, you may lose the formatting. Any
calculations are done just as easy in Excel as they are done in Access, and
it is quicker.
As a rule, I format any reports that are used again and again in Access, but
I export data that is for one time use only into Excel and format it quickly
in Excel.
Brigitte P.
 
You can do a macro which will export your data to Excel and then create a
button which will run the macro on the form the user has rights to. The
record source for your macro can me either the query, table, or report (I
think).
The only problem I have encountered with this approach is the location of
the Excel spreadsheet. If you work in a network environment, you may wish to
direct the Excel spreadsheet to the same location the database is stored. If
this is confidential data, you may want to send it directly to the users
local hard drive where the user then can delete or password protect the
spreadsheet. But try the macro approach; the Access help will lead you
through the process.
Brigitte P.
 
Back
Top