Export to excel from access table loses sort order
I have a table that I need to export to excel. Issue is that when I create a macro to export from the table it loses the sort order. Trying to export with formatting replaces my existing spreadsheet rather than updating it.
What are my options with exporting from a query? I do not have the same options available if I choose to export from a query instead of a table using the importexportspreadsheet option.
Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.