I often run queries where large numbers of records are returned…since Excel is limited to how many rows it can contain (65k’ish), I typically just create a table, place the records, then just export to a MS Access database via ODBC. I noticed that there is an option; however when attempting to Export to Excel for ‘Selected Rows’. This is greyed out, though. If I have a customer that really wants the data in Excel (silliness), I would like to utilize this functionality to perhaps place data in seperate worksheets without needing HAVING clauses or what have you.
Can someone inform me how I can get this ‘Selected Rows’ functionality to become accessible?