Using DAO to export access query results to excel

[SHAWTY721 via AccessMonster.com]

Is it possible when using DAO to export results of a parameter query into
excel; to have more than one field from the parameter query to populate a
specific column in the specified excel spreadsheet template that is being
populated with the selected data.

 

[Alex Dybenko]

Hi,
sure you can. first you open recordset on your query, supplying parameters
using Parameters collection, then open excel sheet like here:
http://accessblog.net/2007/03/export-mixed-type-data-to-excel.html

and then loop through records and put data into required cells

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com