Aren't you lucky to still be using Sage 100 (2106).

Here is a link to a YouTube video that explains Excel ODBC queries with Sage  (MAS90 and Sage 100 2016) data:

https://www.youtube.com/watch?v=ssEmgcBg-_w

I was rocking and rolling doing Excel queries until the Sage 100 (2018) update.  Because of Personal Identifying Information (PII) encryption in the Payroll data tables, Excel data queries and custom Crystal reports that rely on the payroll module are no longer possible.

My solution was to learn EXPORTING using the Visual Integrator module.  What you do is eventually create a CSV file of the payroll data you might want.  Then you can read the CSV file with Excel.

Good Luck!!!

Aren't you lucky to still be using Sage 100 (2106).

Here is a link to a YouTube video that explains Excel ODBC queries with Sage  (MAS90 and Sage 100 2016) data:

https://www.youtube.com/watch?v=ssEmgcBg-_w

I was rocking and rolling doing Excel queries until the Sage 100 (2018) update.  Because of Personal Identifying Information (PII) encryption in the Payroll data tables, Excel data queries and custom Crystal reports that rely on the payroll module are no longer possible.

My solution was to learn EXPORTING using the Visual Integrator module.  What you do is eventually create a CSV file of the payroll data you might want.  Then you can read the CSV file with Excel.

Good Luck!!!

You can still use Crystal Reports for Payroll Tables on Sage 100 2018 and higher, but it does require additional steps if you want to display Personally Identifiable Information (PII) fields.

Refer to KB88325 if you need help displaying Personally Identifiable Information (PII) fields on Custom Crystal Reports in Sage 100 2018 and higher