Exporting a Report to Excel

  • Thread starter Thread starter Stan
  • Start date Start date
S

Stan

I am using the office link to convert an Access report to
Excel. When I view the Excel spreadsheet only two cells of
one line are populating the spreadsheet.

The report is based on a query and calculates various
totals.

What can I do to get the full report exported to Excel.

I need to have the summary totals on the excel report and
would perfer not to rebuild the totals in Excel.
 
For reports that don't export cleanly into Excel I've *sometimes* had very
good luck with the following:

Export to Word instead, Select All (Ctrl-A), Copy (Ctrl-C)
Paste into Excel (and sometimes needing to Paste Special a 2nd time "As
text" over the existing formatting)

HTH,
 
Back
Top