Home Forums SQL Server 2012 SQL 2012 - General Output a query as an Excel file RE: Output a query as an Excel file
bgalway
Ten Centuries
Points: 1158
More actions
July 23, 2015 at 7:12 am
#1814356
A possible, easy and repeatable option: connect to SQL via Access (ODBC, for example).In SQL, create a View that has your query results.Access attaches to Views and the results can be copied/pasted or exported (via Access) to Excel.