Union SQL and Excel Data

[BKNewton29]

I currently have two data sources

1 A SQL Data table
2 An Excel data table

Both tables have the same fields.

Is there a way of unioning them in MSQuery so I can return all the results in one table?

I had a go below but it didn't like it

SELECT * FROM "dbo"."VMS_Nominal_SUMMARY" UNION ALL SELECT * FROM 'Z:\MIRF\Prot\EBG\MM-prot.xlsx'.Manual$

thanks