Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. SQL Server 2012 DQS Export to 64-bit .xls Excel file fails with error

SQL Server 2012 DQS Export to 64-bit .xls Excel file fails with error

View products that this article applies to.

Symptoms

When using SQL Server 2012 Data Quality Services, on a computer where Microsoft Excel 64-bit is installed, consider the following scenario
1. You use Data Quality Client to run a Cleansing or Matching Data project

2. You complete the necessary steps to reach the final Export page of the data quality project.

3. You attempt to Export cleansing results, to Destination Type "Excel File"
You click the browse button to specify an existing Excel file to export to.
You specify the export file type as "Excel 97-2003 Workbook (*.xls)" and point to a file with the .xls extension.
You click the Open button to choose the destination file.

4. You click the Export button to run the export action.

An error appears:
"File Download Failed, Check that the export destination file does not already exist."

↑ Back to the top

Cause

In this scenario exporting to the Excel 2003-2007 file type *.xls fails, which is a bug.

DQS should be able to export to *.xls when Microsoft Excel 64-bit is installed without error.

↑ Back to the top

Resolution

Service pack information for SQL Server 2012

To resolve this problem, obtain the latest service pack for SQL Server 2012. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2755533 How to obtain the latest service pack for SQL Server 2012

You can now browse and specify the export file which has *.xls extension and run the Export action without the error, when Excel 64-bit is installed on the computer.

↑ Back to the top

More Information

When using 64-bit Microsoft Excel 2007 or 2010 on the computer where Data Quality Client is installed, you can export only to the backward compatible Excel 2003-2007 *.xls file format, or choose another Destination Type such as SQL Server or CSV (a comma delimited text file).

It is expected behavior that SQL Server 2012 Data Quality Client cannot export data projects to the newer *.xlsx file format when the Microsoft Excel version installed is 64-bit. This is by design.

When using 32-bit Microsoft Excel 2007 or 2010 on the computer where Data Quality Client is installed, you may export to *.xlsx *.xls, or choose another Destination Type such as SQL Server or CSV.


Exporting from a DQS Cleansing Project
http://technet.microsoft.com/en-us/library/hh213061(sql.110).aspx#Export

Exporting from a DQS Matching Project
http://technet.microsoft.com/en-us/library/hh270289(sql.110).aspx#SurvivorshipandExportStage

To view the version of Excel and detect if it is 64-bit or 32-bit.
In Excel 2007
Click the circular Office button in the upper left. Choose the options button, view the references page. View the about section.

In Excel 2010
Click the File tab on the ribbon,
Click the Help page, and note the version on the right pane under the heading About Microsoft Excel.
The version number and architecture will be listed, such as (32-bit) or (64-bit)

↑ Back to the top

Keywords: kbtshoot, kb

↑ Back to the top

Article Info
Article ID : 2712972
Revision : 1
Created on : 1/7/2017
Published on : 11/16/2012
Exists online : False
Views : 375