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

Thank this author by sharing the article on social media. If you have any questions or comments, please leave a reply below:

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s