Is there any code on how to export a filtered recordset to an excel file?
Printable View
Is there any code on how to export a filtered recordset to an excel file?
You have to create an excel application object and then
execute an Insert Into [SHEET1$] Values rs!field1, rs!field2 etc