xls file encoding

[bbwolff]

i have problems with saving data to xls as it turns some characters in gibberish

čšž goes to Cyrillic letters Љж... the rest looks rather normal... i'm not really sure Cyrillic letters are the right ones

i use this line

DoCmd.OutputTo acOutputQuery, "koordinator", acFormatXLS, strpath, False

output to has an option to add encoding

.OutputTo(ObjectType, ObjectName, OutputFormat, OutputFile, AutoStart, TemplateFile, Encoding, OutputQuality)

but I'm not sure what to write as the value for encoding
anyone knows? I'd like to set the default encoding as Central-European.

 

[Cronk]

Have you tried the TransferSpreadsheet method?

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qryYourQuery", strSaveFileName

 

[bbwolff]

i found an old forum post
it's a bug in acces 07 that was fixed in 10
there is a workaround, i had to export it to xlsx form and it works normally

 

[Frothingslosh]

As a rule, if you find an answer elsewhere, it's considered polite to post it in the thread you started here. That way, if someone else having the same problem digs up this thread, they'll have the answer available instead of having to re-invent the wheel.

 

[bbwolff]

Haven't I done that?

 

[Frothingslosh]

Whoops, guess you had. Sorry about that! Somehow I skipped over the middle third of that sentence.