Link to home
Start Free TrialLog in
Avatar of GPSPOW
GPSPOWFlag for United States of America

asked on

Access DoCmd.OutputTo

What is the format to output an access query results to the DoCmd.OutputTo an Excel file?

My query name is qry_test1
My output will be   "Path\" &  "test" & the previous month end date & ".xls"

Thanks

Glen
ASKER CERTIFIED SOLUTION
Avatar of Joe Howard
Joe Howard
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GPSPOW

ASKER

thanks

Glen
My pleasure.