yes
>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?
>
>
>>You have to double single quotes inside a string literal
>>
>>>
>>>I need to put
>>>
>>>Bulk Insert qryICECLImport from @FileName with (FieldTerminator = ',' , RowTerminator = '/n')
>>>
>>>
>>>into a string - or at least I'm assuming I need to because SQL is not liking the parameterized file name, it's got the red squiggly line and says 'expecting INTEGER, STRING...' and perhaps that's what I should be asking about - but anyway would someone please remind me how to have quote marks within quote marks. I'm really missing being able to use single quotes (') AND double quotes (")
>>>
>>>Thanks
--sb--