Could it be that the data in that cell is too big for the column that you
are trying to store it in?

Say you are trying to store a string with a length of 255 in a varchar field
that can only hold 100 char's?

Hope it works for you!
Cheers,
Hans

-----Original Message-----
From: Joy [mailto:mssqldba-ezmlmshield-x52489694.[Email address protected]
Sent: vrijdag 25 februari 2005 15:51
To: LazyDBA Discussion
Subject: Error while importing Excel spreadsheet to SQL Server 2000 Databa
se

HI,

I am trying to import an Excel 2000 spreadsheet directly into a SQL Server
2000 database and I am getting the following error. Any help would be
greatly appreciated.

It is a production issue and I have to get this data into the SQL database.

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

Thanks


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




MS Sql Server LazyDBA home page