Exporting Reports

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

Guest

/pHave a report that when opened/printed the format is correct. The reports
shows :
02-276
ED1-300

However when I report to Excel it shows as
-593121
ED1-300
Have checked the formatting from the original table (field is TEXT), through
to the query and the report so I dont know where I've gone wrong!
 
You are going wrong by exporting a report to Excel. You cannot control the
formatting or even the positioning of the data when you export it. If you
want to present your data in Excel, there are two ways to do that.
Well, for starters, forget the OutputTo method exists.
The easiest way is to create a query or queries to present the data and use
the TransferSpreadsheet to create the Excel file.
If for some reason, that is not sufficient, you will need to use Automation.
That is, through VBA in Access, create an instance of Excel and manipulate
the Excel object model. This is a lot of work, but it allows you to present
the data any way you want to including formatting, coloring, etc.
 
Back
Top