What difference are you referring to? Hard to answer the question without
knowing more specifically where you are noticing the difference. However,
the bottom line: Access is a database, Excel is not. Excel does not have a
real table structure, the data types are more limited, there is no provision
for indexing fields, ... Excel can act somewhat like a database, but the
SQL interpreter will have limitations due to these structural differences.
Then, on the other side of the spectrum, Access implements some non-standard
SQL syntax and functions. Access is not unique in bending the SQL standards
- it is the curse of any standard in computing: sticking strictly to the
defined standard ensures compatibility and portability but at the expense of
function. Having added functionality customized to a particular database
engine leads to compatibility issues...

"Blackhorse" wrote:

Excel and Access differ in the way SQL looks at tables to pull information
from a database. Why are these not interchangeable so the same statement can
be used in both.