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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2007-12-03 : 09:37:45
|
| Hi i've 2 questions.Q1 . I'd like to know if i have a data conversion before i export my data out to excel will it hold the data types in excel. Q2. If i sort the data before i export my data out to excel will it hold the sort |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-12-03 : 10:28:17
|
| A1. Maybe. Excel(VBA) has way few data type than SQL has. Normally you don't need to convert them first.A.2 Yes. |
 |
|
|
|
|
|
Data conversion to excel