output to excel

[kerrigirrl]

My access help isn't working. If I want to output a query to excel, what's the abbreviation for excel? Also, is 1 correct for autostart?

DoCmd.OutputTo acOutputQuery, "SRCus", ???, "SalesRep by Customer", 1

Thanks in advance!
Kerri

 

[gwinn7]

Example:

DoCmd.OutputTo acOutputQuery, xtempquery.Name, acFormatXLS, , True

The prefix to be on the lookout for is the "acFormat" constants.

Try looking up the "OutputTo" option in the Help.

Here is the list of them...

acFormatActiveXServer
acFormatHTML
acFormatIIS
acFormatRTF
acFormatTXT
acFormatXLS


Gary
gwinn7