Toad World® Forums

Quick Export of Money datatype is stored as text in excel instead of number

I work in a large Microsoft SQL Server data warehouse that unfortunately uses the Money datatype in many places. For years I have been exporting data to excel and sending off to whoever. Recently though, since I upgraded to TDP, when I quick export a dataset to an excel file, the money datatype columns are stored as text. BUT, if I do a quick export to an excel instance, the money columns are stored as numbers and it works fine. So this issue only occurs when exporting straight to a file.

If it makes any difference, we are on office 2007.


I was able reproduce your problem and we are sorry about it. I created task QAT-8499 and we will fix this issue.


Great, thank you!