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.