How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.

How to Use SQL Statements in MS Excel. With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations.

Macros Now that we’ve written a simple SQL query in Excel, let’s create a Macro that will print the entire table from the database into the Excel sheet.

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.