Export an ADO recordset to Excel? 1

[codemech]

I want to export and ado recordset to excel without having to use code to create the excel spreadsheet and loop through the recordset to populate the cells.

I want to use something like the docmd.outputto command. Has anyone been able to get this to work?

Codemech

 

[rsinj]

you can use DoCmd.OutputTo but not with an ADO recordset.

create a generic QueryDef (if your query isn't fixed), in your code, you can change the SQL tied to the QueryDef (if you need dynamic SQL), and then use DoCmd.OutputTo on the QueryDef.

 

[codemech]

Will this work with an .adp file? I thought the QueryDef object was used with .mdb files?

Codemech