Language problem in exporting data

B

bijan

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
 
K

Ken Snell \(MVP\)

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