Trying to Import csv\txt file with just employeeNumber column. To Add Active Directory Accounts to a Distribution Group in Active Directory

Appreciate any help with this..

txt file example:


sample script but we are a google shop do not have exchange, and every time I run it. Script is unable to recognize employeeNumber attribute.

$Path = "c:\Test\BonusUsers.csv"

ForEach ($Emp in (Import-Csv $Path))
{   $EmpID = $Emp.employeeNumber
    $User = Get-ADUser -Filter {employeeNumber -eq $EmpID} 
    If ($User)
$User | Add-ADGroupMember -Identity "Bonus_List" -Members $EmpID } }