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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-08 : 15:39:29
|
Tony writes "How can I transfer data from an excel spreadsheet into SQL2K without errors. I have tried DTS to transfer data that is only 800 words long per col (x2000 cols). All I get is: '...data is too large for the specified buffer size'.
The datatype used for this column is 'ntext'. I have also used 'text' and 'nvarchar' but to no avail - I kept getting the same message. I have also used a query to insert the said column - I only tried one row. But when I open the table to see if the text has been inserted, all I found in the column was .
What do you thing I am doing wrong? Can someone please help.
Best regards
Tony" |
|
|
|
|
|
Transfering Data