Can you export an Access Report into a Excel spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you take a Access report that is based of several different queries and
export it to an Excel spreadsheet?
 
Can you take a Access report that is based of several different queries and
export it to an Excel spreadsheet?
Click to expand...

Run the report.
Click on the Office Links toolbutton.
Select Analyze with Excel
 
TKM said:
Can you take a Access report that is based of several different queries and
export it to an Excel spreadsheet?
Click to expand...

Yes you can. Use the command button wizard and use the Report
Operations:Send to file option. You can even go into the properties and make
the button fully automated by adding the other variables to the command :
DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS,
"Fill_in_the_file_name_here.xls", -1
 
Perfect Joseph..Just what I was looking for. Will it show the same way in
Excel as it does in Access?
 
TKM said:
Perfect Joseph..Just what I was looking for. Will it show the same way in
Excel as it does in Access?

"Joseph" wrote:
Click to expand...
Sort of. The record source of the report will be displayed across the top,
while subreports will be displayed down.

Why do you need to save it to an xls anyways?
 
I really dont need them to be Access reports but my work does want them to be
Excel spreadsheets. This is goiong to be tough as they have groupings,
sorting with different totals etc. You cant do that in Excel as far as I
know? I was thinking about just exporting them to excel.
 
You can group in Excel. It is just not really pretty. As long as the other
workers do not need to manipulate the data, output the reports to another
type, like acFormatRTF(rich text format - document) , or acFormatSNP(Snapshot
- picture) or teach them how to view the reports in Access(use a
switchboard). As an RTF, it will keep its format, and is slightly editable.
While SNP is just a picture that requires the Access Snapshot Viewer program
to be installed on the other computers.
 
Thanks agian most appreciated!

Joseph said:
You can group in Excel. It is just not really pretty. As long as the other
workers do not need to manipulate the data, output the reports to another
type, like acFormatRTF(rich text format - document) , or acFormatSNP(Snapshot
- picture) or teach them how to view the reports in Access(use a
switchboard). As an RTF, it will keep its format, and is slightly editable.
While SNP is just a picture that requires the Access Snapshot Viewer program
to be installed on the other computers.
Click to expand...
 
Back
Top