Hi all,
I have project with VB6.0 and Access-2003. I have datagrid and ADODC as datasource to retrieve records from database. To export the data of datagrid to Excel I am using Copy From Recordset Method. It works fine but when I apply Filter on Adodc Recordset, The Copy From Recordset Method Export All Records in Excel File. I want to export ony Filtered Recordset to Excel File. How can I do this?
Thanks
Neelesh.
I have project with VB6.0 and Access-2003. I have datagrid and ADODC as datasource to retrieve records from database. To export the data of datagrid to Excel I am using Copy From Recordset Method. It works fine but when I apply Filter on Adodc Recordset, The Copy From Recordset Method Export All Records in Excel File. I want to export ony Filtered Recordset to Excel File. How can I do this?
Thanks
Neelesh.