Actually, the delimiter should be in proper format. Excel accepts tab delimited and other formats. But, the format web users want, possibly is not there in BCP generated text file.
Generally, people use tab delimited columns and (\n) delimited rows. If you specify all these in your -r and -t switches, you may solve this problem.
Post us the way you generate File from BCP out statement, this may be helpful for us to figure out the root of problem.
- Som Dutt