In MS Excel, "Save" spreadsheet as tab-delimited text. This is the best way to deal with XL, imho ... and here's an example of such output; te conntent of "cpqa_AF_xlsDataTDIdea(td).txt"
Zany, Assignment quisling.tito.com yes 2013-02-04 11:38:01.760
Captain, Theodorus mike.twentysixteen.com yes 2012-12-14 11:59:02.110
Wynn, Cruikshank ss.nautpott.com no 2011-07-26 07:52:15.007
The TSQL ...
USE [cpqa]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[cpqa].[tbl_AF_xlsDataTDIdea]') AND type in (N'U'))
DROP TABLE [cpqa].[tbl_AF_xlsDataTDIdea]
GO
CREATE TABLE [cpqaAnswers].[cpqa].[tbl_AF_xlsDataTDIdea](
[name][nvarchar](73),
[email][nvarchar](42),
[fmUser][nvarchar](5),
[sIn][datetime]
)
BULK INSERT [cpqaAnswers].[cpqa].[tbl_AF_xlsDataTDIdea] FROM 'C:\cpqa_AF\cpqa_AF_xlsDataTDIdea(td)'
SELECT [name]
,[email]
,[fmUser]
,[sIn]
FROM [cpqaAnswers].[cpqa].[tbl_AF_xlsDataTDIdea]
GO
This take on Excel input is strictly tab-delimited-required. If the tab-delimited file is not data separated by single tab there will be errors at the BULK INSERT stage, guaranteed.