for some reason, SQL cannot open the file below. I checked the path and in the run prompt it opens fine. It's a synax error I think but the error doesn't say, it's just a generic error:
BULK INSERT tablename FROM 'c:\Documents and Settings\sss\Desktop\myfile.txt'
BULK INSERT tablename FROM 'c:\Documents and Settings\sss\Desktop\myfile.txt'