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 |
|
daarsh
Starting Member
1 Post |
 Posted - 2009-08-19 : 06:49:53
|
| I'm writing a bcp query to export a set of columns from a table to an excel. A column has varchar data(eg: 03/09), when it is been exported to excel it is automatically formateed to datetime as 9-March. How to retain the value 03/09 as 03/09 in an excel when exporting. Thanks in advancePRIYADARSHAN V |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-08-19 : 07:05:07
|
| Nothing can do in the Query!. This is the formatting problem in excelSenthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
|
|
|
Is it possible to export a 'mm/yy' format to an ex