ffs, I did google!
stop responding back each time saying "did google them".
if you got nothing decent to say, I rather you don't respond!!!!

ok so I managed to get it working by changing the directory from C: to D:
But still don't understand why it does not work with C:?

did that and it still does not work.
same error Error = [Microsoft][ODBC Driver 13 for SQL Server]Unable to open BCP host data-file

So I guess no one here knows the solution to my problem.

I am a newbie so I wouldn’t know but it’s sad to see no one can help.

thanks Lowell for your detailed reply but unfortunately, it still not working.
Maybe I am doing something wrong but I tried moving the file into C:\Data but no luck.

the link you included in your previous message I read already before I posted my query on here.
I didn't find that link useful to help me solve my problem,...

I try executing the following 
declare @sql varchar(8000)
select @sql = 'bcp [sample].[dbo].[fams] out C:\Users\mp88_\OneDrive\Desktop\samplefile.txt -c -t, -T -S' + @@servername
exec master..xp_cmdshell @sql
but I...

well obviously I did google it thank you very much before posting it on here!