export to xls

D

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
 

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

export to excel - encoding problem 0
Access export to excel produces "unreadable data" 0
Add Date to export file Name 1
TransferSpreadSheet - Export to XLS 1
TransferSpreadsheet WITH Save Formatted option 1
Prompt for file location Export to Excel 4
Language problem in exporting data 1
Export to excel file in Access 1

Top