When I create a table in an Access mdb database and populate it with special characters such as Æ or ß, these characters are exported to the Excel spreadsheet, without a problem.
The problem is this: We use adps with the tables and queries in SQL Server 2008. In the VB code of the Access reports, we are using the DoCmd.OutputTo command to carry out the export to Excel. Carrying out the export in this way, the special characters are not preserved and appear in the Excel spreadsheet as question marks or strange characters.
How can these special characters be preserved when exporting to Excel using the DoCmd.OutputTo command?
Is there something that can be done from Excel to retrieve these special characters that don't show up correctly after the export, to reset them, so to speak?