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 |
|
philmccor
Starting Member
2 Posts |
 Posted - 2005-03-15 : 04:31:23
|
| Why does the transform change the datatype.In SQL the results of a SQL Query as the Source are decimal and when they get written to the Excel worksheet they are written with the ` text qualifier and hence are treated as strings within XL.Any solutions ? |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2005-03-15 : 11:42:16
|
| check the format of that column in xls. If it's text, then the data imported will be converted to text. |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-03-15 : 11:46:23
|
| Could it be something with the regional settings and how XL interprets the decimal point.As . or as , ???rockmoose |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-03-15 : 12:43:07
|
how many rows are you exporting?excel uses first 8 rows to resolve a datatype if i'm not mistaken.Go with the flow & have fun! Else fight the flow  |
|
|
|
philmccor
Starting Member
2 Posts |
Posted - 2005-03-16 : 02:56:02
|
| I managed to get it workign by using ActiveX Script to delete from the worksheets, then you can issue a drop table with a SQL task against the XL connection and a create table.strange - but thanks |
|
|
|
|
|
|
DTS Export to Excel