I need to import an Access DB into SQL - no big deal there. However, the data was not controlled at all and there are a ton of duplicate entries. Is there a way to delete duplicates - and should I do this in Access before I import or is it easier to do it in SQL Server after the import? Thanks.

I don't think it is materially easier on one system or another. I guess if I were doing it, I'd try to clean up the data before it got into my "production" database, rather than importing garbage and then trying to clean up the mess ... :)

As for the duplicates, you may want to refer to this thread: http://p2p.wrox.com/topic.asp?TOPIC_ID=3550

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com