Getting error "Some row has more columns that defined" when trying to export data from an excel file (4333694)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Getting error "Some row has more columns that defined" when trying to export data from an excel file
Description

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.
Cause

One of the columns header in the excel file has an space in the end.
Resolution

WORKAROUND
Remove the space in the column header
STATUS
Waiting for fix in a future release of Toad for SQL Server
Defect ID

TSS-775.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title