Posted on: 4/1/2015 4:32:02 PM | Views : 657

I've researched this for hours but I'm still getting this error (see below). My setup: SQL Server 2014 Express. Exporting a table called 'locations' to Excel 2010, file name = "SqlExport.xlsx". The worksheet is empty except for column headings which are identical to those in the 'locations' table. I've saved the workbook and closed it. In the wizard: Choose a Data Source:     SQL server Native Client 11.0     Server Name: 'machine\sqlinstance'     Windows Authentication     Database: 'Staging' Choose a Destination:     Microsoft Excel     Excel file path: C:\Users\Tim\Downloads\SqlExport.xlsx     Excel version: Microsoft Excel 2007     'First row has column names': checked. Specify Table Copy or Query:     'Copy data ...

Go to the complete details ...