Peter: You are absolutely correct! - and very generous of you to let me down in such a face-saving manner. That'll teach me to shoot off a comment without testing.

The article demonstrates some valuable techniques, but for a situation like this, seems overkill. My lazy method (using DTS): use the DTS import wizard, check off Drop and Recreate, and...

Try http://www.counterpunch.org/descoto06092004.html, or http://www.counterpunch.org/fons06082004.html for some balance against the Reagan as Great World Leader mass media message. Forget the pride stuff, lets face facts.

Thanks for the reply to altering the system functions. Makes plenty of sense versus the original process.

Re how I used it, nothing too exciting, I'm afraid. I made a couple...

Like anybody needs any more suggestions...

1. Field names all caps - if you happen on a case sensitive situation you will not go crazy.

2. Primary key as ID_TABLENAME. Foreign keys...