I see several options. Import/Export is one option, so is Bulk Copy. I use a Red-Gate tool SQL Data Compare which may be a bit more than what you are looking to do, but will do the trick as well.
Kurt W. Zimmerman
New York, NY