I try to import data with import wizard and ODBC wih following SQL statement:
SELECT................WHERE ((Left([ITEMNUMBER],2)="PZ")) OR ((Left([ITEMNUMBER],2)="PP"));
Error message from MS ODBC driver says: Two arguments expected.
So I have changed separator from "," TO ";" but there is another problem with syntaxe,of course, because ";" ends the SQL statement. I have tested this SQL statement in Access without problem.
The question is: How to change the original statment to be used in the import wizard? I cannot find solution in this forum.
Thanks for some idea.