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
 
P

PieterLinden via AccessMonster.com

Dasha said:
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

Use the OpenSaveFile API to prompt the user for a file.
http://www.mvps.org/access/api/api0001.htm
 

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

Top