Export to Excel only the filtered data
I have a Form where the data is filtered seleting From Date and To Date.When i click the filter button the count is showing correctly.But when i click the export button it returns with all the records.
Now the recordset have become huge,the export is not happening since i use Access 2000.It says there is limitation which this record exceeds.
Is there any Vba code that can be used to export only the selected date datas to excel and how to avoid overwriting on the same file? Can somebody help on this please.Thanks