export to xls

[Dasha]

Hi,
I want export some query to excel file. If I use DoCmd.OutputTo, but fields
which are filled with my native language (czech) are corrupt and I can't find
description of parameter encoding of this method.
I've tried to use DoCmd.TransferSpreadsheet but I don't know the name of
exported file, I want to let the user to choose.

thanks for any help

 

[Ken Snell]

This article also may be of assistance:

Browse to a single EXCEL File and Export Data to that EXCEL File via
TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#ExpBrowseFile