Creating a new table from query results can help you build a database of your clients, employees, expenses and other business details by allowing you to select certain columns from existing tables.

To create a table from your query results, run your query, then return to the Query window by selecting Close from the File menu. Follow the instructions in one of the following two sections, ...

The specified columns are dropped when the table is created. Indexes are not copied to the new table. Both of these forms create a table without rows. You can use an INSERT statement to add rows. Use ...

A make-table query is what you need.<BR><BR>You can generate a SQL string which constructs a Table (using either existing fields from other tables, new calculated fields, or constant fields).<BR ...

Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.

Create a Form for a Query or Table, Edit & Delete Data, Navigate through Records, Add & delete Rows and Records in a Form in Access.

You should see the data listed (Figure A). Figure A Continue adding data to the table in the same fashion. And that’s all there is to creating a table and inserting data into it on MySQL.

Learn how to handle column name changes in Power Query and prevent workflow failures with expert tips and dynamic solutions.