Save Query Results As Table. You should normalize poorly designed tables in your database so it will run more efficiently. Cant get any simpler than that.
To quickly export the query results select all the records in your table eg by picking any cell on the grid and then using the keyboard combination of Ctrl A. However this doesnt work for for joins. However I need to export or save the result in an Access table in order to export it to an ascii file delimited.
Exporting Data from Power BI Desktop to Excel and CSV Part 1.
BigQuery saves all query results to a table which can be either permanent or temporary. How to store results from following query into another table. An arranged order of rows ascending or descending of one table can also be inserted into another table by the use of SQL SELECT statement along with ORDER BY clause. You can then look at the SQL View to see how Access accomplishes this task.