D
David
I have used the Data Import External Data, New Database Query, and via our
database at work, have 3 different tables (and the links are all good). I
have eight(8) different criteria fields that the query is filtering through.
However, 3 of these 8 have about 5 different "OR"s which total 125 rows of
criteria.
Originally I write this all on one line in Microsoft Query in the Criteria
area. When I click refresh and/or Return Data to Excel, it works no problem.
However, if I go back into edit the query, it comes back with 125 individual
lines of criteria.
Is this too much for Excel to handle? Reason I ask is I receive a
ORA-00936: missing expression error when I try and refresh. And if I try
and Return Data to Excel, same error message and it won't let me do anything
until I change the Criteria again.
database at work, have 3 different tables (and the links are all good). I
have eight(8) different criteria fields that the query is filtering through.
However, 3 of these 8 have about 5 different "OR"s which total 125 rows of
criteria.
Originally I write this all on one line in Microsoft Query in the Criteria
area. When I click refresh and/or Return Data to Excel, it works no problem.
However, if I go back into edit the query, it comes back with 125 individual
lines of criteria.
Is this too much for Excel to handle? Reason I ask is I receive a
ORA-00936: missing expression error when I try and refresh. And if I try
and Return Data to Excel, same error message and it won't let me do anything
until I change the Criteria again.