>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.
If it's not broken, fix it until it is.
My Blog