Language problem in exporting data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Try using the DoCmd.TransferSpreadsheet action instead. And no need to
create an instance of EXCEL before doing the export.
 
Back
Top