How to export SQL server query result to excel?

(0) Share

Report

Posted on by nagaraj

2,340

Hi recently in my requirement I was faced some difficulty in exporting SQL server query result to excel.

Exporting data with right click on database name > tasks > export data, selecting Excel and mapping fields seems to be difficult apart from that just export the data by selecting export to file option in top action pane and execute the query it will generate .rpt file.

1) After generating .rpt file open MS excel select the From Text in Data tab, then select the file click on next, next........

2) Without .rpt file by default after running Query in sql editor it showing results in bottom of the query click on top left corner in results then all the results will select, right click then click on copy with headers then open the excel file and paste it.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

nagaraj 2,340 on at

Like (0)

Report

Hi recently in my requirement I was faced some difficulty in exporting SQL server query result to excel.

Exporting data with right click on database name > tasks > export data, selecting Excel and mapping fields seems to be difficult apart from that just export the data by selecting export to file option in top action pane and execute the query it will generate .rpt file.

1) After generating .rpt file open MS excel select the From Text in Data tab, then select the file click on next, next........

2) Without .rpt file by default after running Query in sql editor it showing results in bottom of the query click on top left corner in results then all the results will select, right click then click on copy with headers then open the excel file and paste it.

Thanks

Was this reply helpful? Yes No