Import and ODBC and ACCESS

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • SQL import error

    Hi,
    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.
    Lubos