RE: Error while importing Excel spreadsheet to SQL Server 2000 Database

RE: Error while importing Excel spreadsheet to SQL Server 2000 Database

 

  

Try this:

http://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3BQ281517


-----Original Message-----
From: Joy
[mailto:mssqldba-ezmlmshield-x52489694.[Email address protected]
Sent: Viernes, 25 de Febrero de 2005 08:51 a.m.
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