How to Solve: SQL Server 2012 Data Quality Services Does not allow you to export the cleansing or matching results to an Excel file if you are using 64-bit version of Excel

Standard

While I was working with DQS, I got an error that didn’t allow me to export the cleansing results to an excel file. I searched to find that it was a known issue for the 64 bit version of Excel. So based on what I found, this is how I was able to solve the error:

1. Downloaded and Installed the SQL Server 2012 SP1

Downloaded and Installed the SQL Server 2012 SP1

2. Ran the DQSInstaller.exe -upgrade command in the command prompt

Ran the DQSInsaller.exe -upgrade command in the command prompt

That’s about it. And I was able to export the cleansing results to an 64 bit version of the excel file.

Screenshot 1:

export the cleansing results to an 64 bit version of the excel file.

Screenshot 2:

Advertisements