>>>so, if I'm understanding you - I need to have
>>>
>>>

>>>Set @BulkCmd = 'Bulk Insert qryICECLImport from ' + @filename + ' with (FieldTerminator = '','', RowTerminator = ''\n'')'
>>>

>>>
>>>Where the '' is actually 2 single quotes?
>>>
>>Yes. You can always add print @BulkCmd to see it.
>
>Yeah, I do that for things like this to make sure they 'look' right.
>Here's what I'm working with:
>

>declare @filename nvarchar(50), @BulkCmd nvarchar(200)
>Set @filename = 'c:\download\dropbox\cat\qryICECLExport.csv'
>set @BulkCmd = 'Bulk Insert qryICECLExport
>    from ' + '' +  @filename  + '' +  
>    ' with (FieldTerminator = '','', RowTerminator = ''\n'')'
>print @BulkCmd
>exec(@BulkCmd)
>
>** and the messages I get when I execute the above block
>Bulk Insert qryICECLExport
>    from c:\download\dropbox\cat\qryICECLExport.csv with (FieldTerminator = ',', RowTerminator = '\n')
>
>Msg 102, Level 15, State 1, Line 2
>Incorrect syntax near 'c:'.
>Msg 319, Level 15, State 1, Line 2
>Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
>

>The only thing I'm seeing that's probably not correct is that there should be quotes around the c:\.... I've tried
>

>Set @FileName = '' + 'c:\...csv' + ''
>

>but that doesn't put the quotes around it either.

Try

declare @filename nvarchar(50), @BulkCmd nvarchar(200)
Set @filename = 'c:\download\dropbox\cat\qryICECLExport.csv'
set @BulkCmd = 'Bulk Insert qryICECLExport
    from " ' + @filename  + 
    '" with (FieldTerminator = '','', RowTerminator = ''\n'')'
print @BulkCmd
exec(@BulkCmd)

In other words, try putting file name in double quotes.