Nadrek (2/12/2014)
Bah; no need for a wizard for a few hundred rows on a one-off import when a simple EXCEL formula creates your INSERT statements for you.
=CONCATENATE("INSERT INTO #YourTable VALUES ('",A1,"')")
Grab the handle on the bottom right and drag the formula down.
IMHO, there is nothing wrong with using or at least being familiar with the Import/Export Wizard.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/