Language problem in exporting data

[Guest]

Hi All
I used this code to export my query result to Excel
Dim XL As Object
Set XL = CreateObject("Excel.Application")
DoCmd.OutputTo acOutputQuery, "qryName", acFormatXLS, "C:\Result.xls",
True
But one of fields that filled with my native language(persian) in access
converted in unreadable format!
any help would be appretiated

 

[Ken Snell \(MVP\)]

Try using the DoCmd.TransferSpreadsheet action instead. And no need to
create an instance of EXCEL before doing the export.