TECH SUPPORT

MS Excel - Data Only (.xls)

Follow

image1742.jpg

 

Excel option require that you have MS Office 2000 or above installed and you have applied the very latest service pack for your version of MS Office.

 

Access TransferSheet Method: By default MARS will use the default method when exporting an Access report. The default method allows for any pass through queries or formatting to exported along with the report. If this process fails, MARS will attempt to use the TransferSheet method to export the report. The TransferSheet method does not allow for passthrough queries or special formating. The report would be exported with data only.

 

When MARS exports reports to excel it names the worksheet "Sheet 1".  Enter a new name in the indicated field if you wish to overwrite this.

 

Workbook Password:  Password protect your workbook by checking this option and entering the desired password.

 

Export Page Ranges

 

image1330.jpg

 

Use this option to select to export all pages, or just a selection.

 

File Summary

image1743.jpg

 

Determine file summary by filling in the required properties as illustrated above.

If properties are not filled in or are left blank, the original properties which

exist in the exported report will be preserved.  To overwrite these with a blank,

enter a space in the field you wish to overwrite.

 

Hint:  For Excel Data Only output, there are some extra options available in Options - General.  Theses are system-wide options and will affect every single Excel Data Only export.  They cannot be pre-determined on a schedule by schedule basis.

 

 

Comments