Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 ERROR

Author  Topic 

WoodHouse
Posting Yak Master

211 Posts

Posted - 2009-08-24 : 04:17:13
Hi

i got this below error while export the excel file data to table..


Error at Source for Row number 10. Errors encountered so far in this task: 1.
Data for source column 74 ('column name') is too large for the specified buffer size.



help me out ..pls...

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-08-24 : 06:12:21
Size of the column is lesser than the data of EXCEL cell
Increase the column width and try


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

WoodHouse
Posting Yak Master

211 Posts

Posted - 2009-08-24 : 06:34:06
Hi Madhivanan

I just export the data DTS will create the table based on the excel file data size..

Go to Top of Page
   

- Advertisement -