Where clause not working for Ms-Access datasource

[#1]

Hi Team,

I want to load data from MS-Access with limiting data from a particular column i.e Team in my case. I have written below script but could not achieve it. It is throwing some error

Attendance1:

  Load Attendance,

Team,

Emp Name,

Designation

Select * from Attandence where Team in('ABC','AVP','PQR');

Please help me.

Thanks in Advance

Regards

Priyanka

[jonathandienst · Accepted solution]

Your SQL expression looks fine, but you need a delimiters for Emp Name, semicolon after Designation, and a SQL keyword before the Select:

Load Attendance,

Team,

[Emp Name],

Designation;

SQL Select * from Attandence where Team in('ABC','AVP','PQR');

(Is the table name spelled correctly).

If you supplied more information about the error, it would allow more accurate diagnosis. "Some error" could be just about anything...