Well I got it working some time but I almost always use the DTS to import a textfile. It's a whole lot easier than the BCP util. <BR><BR>What's your exact problem?<BR><BR>Did you check the BOL? There's a whole lot of info on the BCP util.<BR><BR>(nice to see you also don't have all the answers yourself ;-) )
If I try and import to a table with data types like money and ints, it puts junk in these fields, so I have to use long varchar fields instead.<BR><BR>I also get errors like "Unexpected EOF encountered in BCP data-file" and "string truncated" and it fails to get all the records. I think its having problems with the field and row delimeters, it doesn't seem like an exact science ! <BR><BR>Anyway, I've given up on it now, and am writing something in ASP instead which will no doubt be slower than bcp importing.<BR><BR>Cheers.