JGay,

Both are yes.

Since those 37 columns are nullable, the SP should ignore them. So I think you found a bug. Thanks.

The fix is pretty simple. You can find the following code block, and add the new line to remove those columns from importing list.

IF @DataTableExists=1

BEGIN

-- Check whether the data table has columns that is NOT NULL and is not defined in the Excel sheet

IF EXISTS(SELECT 1 FROM #Columns c WHERE c.ExcelColNum=0 AND c.IsNullable=0)

BEGIN

RAISERROR(N'Some non-nullable columns defined in the table [%s] does not exist in the Excel worksheet [%s].',16,1,@OutputTableName,@WorkSheetName);

END

-- Add this NEW line

DELETE #Columns WHERE ExcelColNum=0;

END

Add

DELETE #Columns WHERE ExcelColNum=0;