>>If you're not dealing with memo fields, I would highly recommend BCP. It's the fastest, easiest way to get data into SQL Server. The only real disadvantage is the problems with memo fields, so you should be fine.
>
>I've heard that version 7 will handle memos in BCP (in fact, I saw something on this at the MS site a while back)...have you heard anything on this front?
I haven't heard this specifically, but I do know that BCP will be greatly enhanced.