Getting error "Some row has more columns that defined" when trying to export data from an excel file
说明
Getting error "Some row has more columns that defined" when trying to export data from an excel file. The table has the same number of columns than the excel file.
原因
One of the columns header in the excel file has an space in the end.
解决办法
WORKAROUND
Remove the space in the column header
STATUS
Waiting for fix in a future release of Toad for SQL Server