The code sample is too much pseudo-code for me to figure out. Looks like I am going to need some more Ibuprofin....

Dick,

You are a freaking genius! I should have thought about having Express & 2000 on the same machine would not necessarily make bcp bcp.

Thanks!

edition: SQL 2005 Express

compatibility level: not sure I understand what this means 

When I run bcp, it gives me an error (cmd prompt error: unknown option x) for the -x...

lemme check into it & I will get back to you

thanks!

Well, I chose BULK INSERT since I figured it would be the fastest way to get the data into SQL from a CSV. I am now...

the problem actually is that bcp does not recognize the "-x" switch which is the example from MSDN

I just didn't know what the example was getting at

Thanks for the quick reply! Just o it is straight in my head, I create the temp table, BULK INSERT into it, then either UPDATE or INSERT based on if...

If the first column is not in "", how would the Format File reflect that?