Are You Unknowingly Working with Terrorists?

[Some links may no longer be available. —Ed.]

With some simple queries in Microsoft Excel, Access, or other report writer, you can compare this list to your company name and address databases. Here I’ll show you how to match up the lists in Microsoft Excel and then in an even easier way with an inexpensive add-in to Excel.

LIST OF TERRORISTS 

The U.S. Treasury’s link to “Specially Designated Nationals” is: www.treas.gov/offices/enforcement/ofac/sdn/index.shtml. Probably the best format is the ASCII delimited format for Windows computers: www.treas.gov/offices/enforcement/ofac/sdn/sdallw32.exe. This will run an unzip file that will place a plethora of data tables in a folder of your choice on your PC. In this list are two files that are most useful: ADD.CSV and SDN.CSV. These are comma delimited files that automatically open in Microsoft Excel. The ADD.CSV file is the addresses and the SDN.CSV are the names of the Specially Designated Nationals.