If I use hash can I not then recover or unhash the SSN like I can using encrypt/decrypt? The SSN will need to be viewed by certain users. ...

i "inherited" a monthly process of running this sp to spit out to a .txt file for a dept to do whatever it is their doing with it. This...

Yes, I'd like to run VBA from within Access. I'm a beginner learning VBA so this will be a challenge.

It is working now for any of those that might run into this problem. I need to add + '''' to the end of the xp_cmdshell statement.

Yes, and still not working properly, but thank you for research

That works great for a one time copy, however, I'd like to use this when I make a change to my "main database stored procedure" I can run script to...

Sorry, I don't understand what that means?  My sp is not in master.