I'd always stayed away from the import wizard in Sql 2005 Management Studio. One, because I really liked the importing functionality in Sql 2000; I could sail through it with little effort (or thought). Two, I've changed jobs and don't have
Read More...
Read the complete post at http://billrob.com/archive/2007/01/05/sql-2005-import-data-from-excel-problem.aspx