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 |
|
vishal_7
Posting Yak Master
127 Posts |
 Posted - 2006-10-16 : 15:07:39
|
| Hello, I am exporting some data via a DTS into excel. I have already created the excel file and it perfectly imports the data into that file. The problem is that it does not format the data properly. It thinks that everything is a varchar, although I formated the columns in my excel file as "number". The weird thing is that once the data is exported, and I go into one of those cells, and go to "format cells", then I can still see that the column is formatted properly, but the data is displayed as a varchar. I would appreciate if someone could help me out? Thanks in advance. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Format Excel Types