Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
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...