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 |
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
 Posted - 2003-03-05 : 09:28:44
|
| Every once in awhile I dump data from SQL tables into Excel for people who prefer Excel. I sometimes use the DTS wizard for this. Lately I've been noticing that Excel does strange things to the data during the translation and this scares me.For example, if I have a column in the SQL table of data type FLOAT, and cell values include -1, -2, 15, and NULL, I see that Excel assigns random three-digit numbers to the NULLs during the conversion process! Why would it do that? Is FLOAT data type causing this?Anyway, I wonder if anyone has suggestions for how I can dump whole SQL tables into Excel, exactly AS IS, without Excel making arbitrary changes.thx |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-03-05 : 09:47:30
|
| Have you considered linking to the data from Excel to a SQL view or table directly? Users can refresh as needed by right-clicking. And you also get the benefits of pivot tables and all that.To me, exporting INTO an excel file doesn't make a lot of sense; Excel isn't good at storing data, it's good a analyzing data stored elsewhere.If it is really slow to return the data this may not be a good option, but if you haven't considered it, it's worth looking into. Our analysts link to SQL directly quite a bit from Excel using pivot tables and it works pretty well for them. - Jeff |
 |
|
|
|
|
|
|
|
any quick, safe way to DTS from SQL to Excel?