We need an MRP report that is just a small subset of the entire 154 p. report and in a format more readily readable by our purchasing buyers. Using a silent connection string, I created a MSQuery table in Excel that brings in the filtered results of MRP Generation from MP_04SuppliesAndDemands giving us just what we need. It had been working perfectly until recently. Now I receive the following error every time I refreash the table: "[ProvideX][ODBC Driver][FILEIO]No Data Found".

When select Edit from the Table menu to open MSQuery and run the query within MSQuery, the current results display almost instantly. However, when I try to return them to Excel, I receive the same error. Further, when I try to preview this table using ODBC Navigator from the Excel menu, it returns: DataSource.Error: ERROR [S0000] [ProvideX][ODBC Driver][FILEIO]No data found. The tables on either side of it preview just fine.

Any ideas?

Thanks!

Doug