Error while importing Excel spreadsheet to SQL Server 2000 Databa se

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

MS Sql Server LazyDBA home page