Language problem in exporting data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bijan - 28 Mar 2007 15:04 GMT

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

Reply to this Message

Ken Snell (MVP) - 29 Mar 2007 01:39 GMT

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

Signature

Ken Snell
<MS ACCESS MVP>

> Hi All
> I used this code to export my query result to Excel
[quoted text clipped - 6 lines]
> converted in unreadable format!
> any help would be appretiated

Reply to this Message