Excel Query for Payroll Information and History

SOLVED

Hello.  We are attempting to get two years of pay history out of Sage 100 as well as other employee information.  I have attempted to use an Excel Query, but I really have no idea what I am doing.  Where do I go to find an expert that knows how to retrieve this information quickly, accurately, etc. based on the parameters and layout needed?  We do not need a report, but rather data that we need extracted.

We are currently on Sage 100c Standard 2016 (Version 5.30.3.0).

And yes, I do know how antiquated we are.  Feel free to call our management and ask why.  :D

I appreciate any direction you can provide.

Thank you!

Gail Briesemeister