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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access export to excel produces "unreadable data" 0
Export query results 2
export to xls 1
Export to spreadsheet error, help please 2
Export Query to Excel 1
Data changes between Access and Excel 2
Exporting query results using VBA 1
Export to Excel with Parameter in Filename 1

Back
Top