Link the spreadsheet as if it were a table. See TransferSpreadsheet in VBA
Editor Help for details.
Create your query based on the spreadsheet.
> I need to create a report on data found in an excel spreadsheet but I
> need to use a query in order to do so. I was wondering if that was
> even possible and if so then how would I go about doing it? Any help
> would be appreciated.