ExcelBanter - View Single Post - Crazy problem when using a WHERE-clause in a SQL query

Jamie Collins

(kuhni) wrote ...

I am really having a very strange problem with my SQL query from Excel
VBA: If I make basic SQL queries to MS Access like SELECT * FROM xyz,
everything works fine.
But when I dynamically include a WHERE-clause I get an "General ODBC
problem" error message. Of course, I checked the statement and tested
the sql query directly in MS Access without any problems, so I am sure
that the sql statement is correct.
First I thought it is because my SQL-string was greater than 255
characters but I already solved this problem but the other one still
remains.

I think you will need to at least post your VBA code and preferably
your table schema and test data.

Jamie.

--