The error is showing that someone has the file open. Do you have it open in Excel, could someone else? Also, ensure the files aren't passworded.

Maybe not give new users the ability to create polls:

Not sure if you meant rows, or comma delimited, so here's both:
USE DevTestDB;
GO

CREATE TABLE #Numbers (Num INT);
GO

INSERT INTO #Numbers
VALUES (1),

--==================================================================================================
--  These variables could be parameters for a stored procedure
--==================================================================================================
DECLARE @pFilePath  VARCHAR(8000)
   ,@pFmtFilePath VARCHAR(8000)
;
SELECT @pFilePath  = 'C:\Temp\test_loading_UnixCommandOutput_to_SQL.txt'
  ...

Sorry, mw112009, but again, Google... SSRS Enable Send subscription by email

I don't mean to be rude, but please try solving your problem first, rather than coming straight to...

Something like this?
SELECT LEFT(N.Name, PATINDEX('% AND %', N.Name)-1) + RIGHT(N.Name, CHARINDEX(' ',REVERSE(N.Name))) AS FirstConsumer,
       RIGHT(N.Name, LEN(N.Name) - (PATINDEX('% AND %', N.Name) + 4)) AS SecondConsumer
FROM...