Search results

Hello guys, I am trying to load a csv to memory in Powershell and query it using an OLEDB driver, and have done this successfully in the past however for this specific query I am getting a syntax error. My query is as follows: SELECT * from csv WHERE [sAMAccountName] NOT IN( $removeList ) A...

Hey guys, I am using PowerShell to parse a massive CSV with the ACE OLEDB driver as its far more efficient than directly importing the CSV and then modifying it as needed. The imported columns are Facility, User, NTUserID, UPN, Last Accessed Date, and Last Enable Date. As this is how the...