Writing MS SQL Query results to Excel file

Question

I am planning to create a stored procedure that will query certain information from a database then write the information to the Excel file. I am planning to execute the stored procedure via Windows Task Scheduler. I have already created the queries but what is lacking is the command that would write to the Excel file. This is for the purpose of auto reporting. I've read about the OPENROWSET but have no idea how it works.

Thanks for your answers in advance.

eeerahul · Accepted Answer · 2011-11-24 10:20:35Z

1

Don’t use OPENROWSET it is read-only. Use the OPENDATASOURCE you can read & write data into it.

Insert into 
OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source={Your Excel File Path};Extended Properties=Excel 8.0')...[SheetName$]
Values (....)

edited Nov 24, 2011 at 10:20

eeerahul

1,6254 gold badges27 silver badges41 bronze badges

answered Nov 24, 2011 at 10:16

Karthikeyan Anbarasan

115 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Writing MS SQL Query results to Excel file

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related