Can you add an extra column that always has a value?

IE

1,2,3,4,,x

1,,,,,x

1,2,,,,x

1,2,3,4,5,x

This way the delimitters will always be there. I use this when using bulk insert with Excel saved CSV files...

There is post SQL Server 2000 SP2 hotfix that fixes issues with xp_sendmail. See:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q320407

I don't believe you can do this with bulk insert, but you can with something called the bcp utility. You can use this to create a format file, and then...