Export Access report to Excel using extended characterset

  • Thread starter Thread starter Twan Kennis
  • Start date Start date
T

Twan Kennis

My Access report contains some characters from an extended characterset
(In Office subset: "Miscellaneous Dingbats" from "Notmal text")
These are WHITE CIRCLE and BLACK CIRCLE.
All characters are formatted with Arial.

When I export my Access report to Excel using the export-function from
the menu,
the output is perfect, and all extended characters are displayed
correctly.

But when I export my Access report using VBA using the follwing command:

DoCmd.OutputTo(acReport, objReport.Name, acFormatXLS, strOutputFile)

The output looks the same, but all extended characters are displayed as
a "?".
I already tried the Encoding-parameter (UTF8, Western, Auto Detect, ...)
in the command above,
but without any succes so far.

Does somebody know the solution to solve this problem?
Thanx in advance.
 
Obviously acFormatXLS as a formatting-value corresponds with the
"Micrososft Excel5-7"
export-format when executing "DoCmd.OutputTo"

Question is: How can I force Microsoft Access to use the "Micrososft
Excel97-2002" format
when running DoCmd.OutputTo.

Greetings, Twan Kennis
SKB Vragenlijst Services, The Netherlands
 
Back
Top