Error imprting union query to excel

[herbc0704]

I have run into a problem in importing a complex union query to excel. I get the following error message.

The Microsoft Office Access database engine could not findthe object ". Make sure the object exists and that you spell its name and the path correctly.

The data that is driving the union is off an ODBC database. I have researched MS Support and found that i have a complex criteria driving the data. The criteria in question is the following
>DateAdd("d",-Day(Date()),DateAdd("m",-3,Date())) And <=DateAdd("d",-Day(Date()),Date())



I have five queries that some variation of the above sorting through dates.

There seems to be no work around for this that I can find, in order to run this from excel. Doing this from excel would be easier as this spreadsheet would be setup a few users desktop and they can get the information at their on pace. These users are not "MS Access friendly".

Is there a fix for this or a less complex criteria. Help greatly appreciated.

[ajetrumpet]

well, if the error is really this:

The Microsoft Office Access database engine could not findthe object ". Make sure the object exists and that you spell its name and the path correctly.

then the criteria has nothing to do with it (or it's not the only problem). MS errors encapsulate entity/object names in single quotes so it's giving you an error msg and telling you that it can't find an object named (blank). So the name of the object you're wanting to export isn't even being read.