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 |
|
Fonzyy
Starting Member
5 Posts |
 Posted - 2008-07-21 : 08:37:22
|
| Hello,I have made a DTS package which returns my query results into an excel sheet. Works fine, but some fields have more then 255 characters. In excel i only see the first 255 characters, i can not change in the destination part of my DTS package the size of 255 chars... Is this possible to change or an failure in Excel ?Thank you.... |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-07-21 : 08:53:06
|
| what version of excel are you using?Em |
 |
|
|
Fonzyy
Starting Member
5 Posts |
Posted - 2008-07-21 : 08:56:19
|
quote:
Originally posted by elancaster
what version of excel are you using?Em
I am using Excel 2003 |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-07-21 : 08:57:02
|
| i think you'll find it was increased in 2007 ?Em |
|
|
|
Fonzyy
Starting Member
5 Posts |
Posted - 2008-07-21 : 09:05:42
|
quote:
Originally posted by elancaster
i think you'll find it was increased in 2007 ?Em
Are you sure ? i can not work here it tihnk with the 2007 version, because of other problems which will come then... thank you for your help... |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-07-21 : 09:08:47
|
| 255 is the character limit for an excel cell prior to 2007. so you can either upgrade or split your source column into 'chunks' of 255 characters before you send it out to excel 2003Em |
|
|
|
Fonzyy
Starting Member
5 Posts |
Posted - 2008-07-21 : 09:13:55
|
quote:
Originally posted by elancaster
255 is the character limit for an excel cell prior to 2007. so you can either upgrade or split your source column into 'chunks' of 255 characters before you send it out to excel 2003Em
Ok,... thank you.... i will try that... |
|
|
|
|
|
|
DTS Package 2 Excel, need more than 255 chars