Users of the Import/Export wizard would be well advised to look at another tool that always ships with SQL Server... BCP. The (B)ulk (C)opy (P)rogram is a command-line program that has been bundled with every version of SQL Server since Sybase. It is the fastest extraction and loading tool that exists for SQL server and can be used in a variety of circumstances. I've used it in challenging situations that the Import/Export wizard was just either not up to the circumstances or was overkill. Exporting data using BCP in native format is an extremely efficient way to move data between SQL Servers, and is an excellent backup alternative for individual tables.

Cheers!

Old Guys Rule: Treachery and old age will overcome youth and skill.