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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export report to excel ERROR - please help 3
Problem when export a report to a pdf file 1
Exporting Access Rpts to Excel 2
Export Report to Excel 1
Export to Excel Cuts Off Data 1
Access 2007 Report Export To TXT Line Wrapping... 2
HowTo save Access report as Excel 97-2002 file using VBA 4
Export report data to Excel 10

Back
Top