How to export sql result to excel,csv,mdb,pdf ?

[Ken]

Hi,

Is there a link or simple code to export the sql server result without using Import / export wizard.

Planning to export result in either excel,csv,accdb,mdb,pdf format

TechIt

 

[bborissov]

Easiest way is to do the script from Excel and then save it with the desired format.
The other way from SSMS is to mark query result records, right click,choose "Copy with headers" and then paste in Excel.

Borislav Borissov
VFP9 SP2, SQL Server

 

[philhege]

And if you want to automate the export, check out

https://msdn.microsoft.com/en-us/library/ms175937(v=sql.105).aspx

(Note: page is version-sensitive. Select your version of SQL.)

-----------
With business clients like mine, you'd be better off herding cats.