copy from record set - code advise

[balu]

im using copy from record set method to transfer querys to transfer the data
like xlsheet.range("a1").copyfromrecordset rst1
how to transfer an query in the same way
like xlsheet.range("a1").copyfromrecordset query1

 

[Alex Dybenko]

Hi,
open query as recordset:

xlsheet.range("a1").copyfromrecordset currentdb.openrecordset("query1")

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