Possible to load with conditions from ODBC datatable?

[#1]

Hi,

I am trying to load data from an ODBC datatable, but as the data is too big, I want to load with some conditions:

OLEDB

CONNECT32 ....

LOAD

week,

Country

FROM Table

where week>= max(week)-10

and country = xx or xx or xx;

But this is not working. Is there any problem with the syntax?

[#2]

Thanks, week format is Number. I'm trying "where week >=Max(Week,10) and wildmatch(country ,'xx','xx','xx')"

Now I'm reloading but it seems quite slow, not sure if it works.

Should the "Where" statement be before "FROM Table" or after it?