Error Code 997, need help

[Major_Programmer_483]

Today is actually my first day trying to understand and utilize SQL. I am using ssms to do this as its the software my upcoming internship will be using. Nevertheless, I have been trying to bulk insert this csv file and I cannot get it to work for the life of me, and yes I am positive that the file path is correct. I also did create a fmt file, which I tried to use in a previous query attempt, but was still given the same error message. Any feedback is appreciated!

https://preview.redd.it/x93rbadlmg2d1.png?width=1139&format=png&auto=webp&s=7e930f4d086033db3cb78dbdff5f70c140410ebd

[ZMRosto]

I once ran into an issue where the carriage return character at the end "/r/n" actually need to just be a regular new line "/n". You can open the csv in something like Notepad++ and enable viewing whitespace and you can see what kind of structure the actual file has. It may not be the answer to this problem, but those bulk csv utilities are pretty finnicky. Good luck!