The number of failing rows exceeds the maximum specified (Microsoft JET Database Engine (80004005): Spreadsheet is full.)

I would like to ask help regarding this error. Here are the details regarding this error.

Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump

Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft JET Database Engine (80004005): Spreadsheet is full.)

Step Error code: 8004206A

Step Error Help File:sqldts80.hlp

Step Error Help Context ID:0

I'm wondering on where can I locate the sp开发者_如何学Pythonecific location of the error for this and other details.

The number of records maxed out the number of available records in Excel. What I did was to copy the records and save it in Excel 2007 as this can hold around 1 million rows.