good post, thanks. I found another way around this similar to the first method you tried. If you save as tab delimited text and then use ssis it works fine...

This doesn't always work. From the research I've done excel is "smarter" (dumber) than that. It actually analyzes the first x rows and it's "majority rules" so if the first...