Ok, we're getting closer - the quotes are there - but now it's telling me it can't open the .csv file and the file IS there, it's not locked, nothing else has it open and I can open it in Notepad with no problem.

(Sigh) I'm going to lunch and I'll take this fight back up when I get back. Perhaps a bolt of brilliance will hit me whilst I'm out....or, someone here will go "You're problem's right THERE" while pointing metaphorically and I'll feel like an idiot.
Either way, I gotta get this to work...


>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.