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