C
Chris Greenwood
Hi all,
Our Access-based reporting application is often used to
generate multiple reports and export the results to
Excel. It currently uses Access 95, but we are going to
upgrade it to Access 2000.
We have found that after changing to Access 2000, the
format of some fields is not preserved when exporting to
Excel. For example:
Text field (field's format property is blank) containing
date: "29 Jan 04" -> 38015
Text fields containing amounts are stripped of thousand-
separators.
Many reports are produced each day, so it isn't very
convenient for users to manually reformat date fields in
the Excel sheets.
The results are the same whether using the OutputTo
method, or using the Export menu after previewing the
report.
Is there a way to get Access to export the data in the
same format as the report?
Many thanks,
Chris Greenwood
Our Access-based reporting application is often used to
generate multiple reports and export the results to
Excel. It currently uses Access 95, but we are going to
upgrade it to Access 2000.
We have found that after changing to Access 2000, the
format of some fields is not preserved when exporting to
Excel. For example:
Text field (field's format property is blank) containing
date: "29 Jan 04" -> 38015
Text fields containing amounts are stripped of thousand-
separators.
Many reports are produced each day, so it isn't very
convenient for users to manually reformat date fields in
the Excel sheets.
The results are the same whether using the OutputTo
method, or using the Export menu after previewing the
report.
Is there a way to get Access to export the data in the
same format as the report?
Many thanks,
Chris Greenwood