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 |
|
akanodia98
Starting Member
6 Posts |
 Posted - 2006-05-25 : 14:23:58
|
| I am trying to transfer data into SQL Server from Excel using DTS.I get error for a particular field:Data for Source Column 3('Col3') is too large for the specified buffer size.I gathered from other resources, that this error is due to some record in the excel sheet for which that particular field is too big.and it reads only the first 8 records to determine a data type.http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281517the fix is to chnage the registry value, as mentioned in the above link. But hat is not an option for me, as that slows down the process a lot.Does any body else has any other suggestion for this?I have an idea, that worked, but for that I have to manually insert a record on the top in the excel sheet, with a big size data in that field (which gives problem), and then run DTS, later delete that record.To automate this idea, I tried to do a DTS from a dummy table (with a record with big data in it) to this excel sheet, but it puts the record at the bottom of the sheet. Is there any way to put this record on the top?Any help in this regard will be greatly appreciated.ThanksNicky |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-25 : 15:07:16
|
| Use a query to do the transfer instead of just selecting the table name. In the query, specify an ORDER BY.Make sure that your dummy row goes to the top by making the data the first in the list. So if you data starts with let's say a's. Then have your dummy row be aaaaaa...Tara Kizeraka tduggan |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
akanodia98
Starting Member
6 Posts |
Posted - 2006-05-25 : 15:27:04
|
| Thanks for reply Tara.I think you misunderstood my question. I am actually trying to add a new record to the existing data in excel, and I want that record to be the first record. |
|
|
|
|
|
|
|
|
Difficulty tranferring Data using DTS