Nested Queries with ADO

[cstimart]

I have a nested query that I created in Access. I'm then trying to use the SQL in Excel/VBA and ADO. I am getting a "syntax error in query expression" error.

I reviewed the code and it appears to be correct, so I am assuming that ADO can't handle the nested query? Or that there is some additional steps that I need to incorporate into the code?

Any ideas?

 

[xenou]

ADO can handle nested queries, so I guess that rules out that. I'm not sure what solutions to suggest though - hard to say without more to go on.

ξ

 

[Fazza]

Suggest you post the SQL. Or otherwise, progressively simplify the code to identify what element of the SQL is syntactically wrong; or going the other way, start from simple SQL and increase the complexity until the problem is identified. Immediate thoughts are use of Access functions not available from Excel, different syntax in the SQL, different wildcard from Excel.