It is a path on the server or your local path? Does the server account you're running it from has rights to this file?
Also please post the exact error message.
>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.
If it's not broken, fix it until it is.
My Blog