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 4.0.0.624, 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.

Hi,

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

Filip

Great, thank you!