Sage 100

I need some MS Access PTQ help. I have created three queries in MS Access to read from Sage 100 Standard data files. Two are pass through queries against ci_item and WO1. The third pulls data from these two PTQ's and makes a calculations (total std cost, total actual cost, avg std cost, and avg actual cost) for each work order. All three of these work well within MS Access. However when I try to pull the data from Access into MS Excel to anylize within Pivot Tables, MS Excel reports an error: ""Data could not be retrieved from the database. Check the datase server or contact your database administrator. Make sure the external database is available, and then try the operation again."" Am I expecting too much? Can we not pull the results from PTQ's into Excel? The connection in Excel is defined but is not pulling. Thanks in advance for your help.

OK, I answered my own question. Two of my calculations (avg std cost and avg actual cost) sometimes resulted in a Divide by Zero error condition. These were preventing the data from being pulled in Excel. As soon as I excluded rows with zero values in QtyPlanned or Qty Complete, the data began to pull into Excel. Lesson learned. Put another way, General Custer says there's a heap of angry people in that direction. Choose another path!!!