Sambadu Posted September 4, 2014 Report Posted September 4, 2014 oka table output Excel lo save cheyali... but table columns name save avtledu.. yemina way undha.. ?? EXEC master..xp_cmdshell 'bcp "select * From master.dbo.final" queryout C:\TEST.xls -c -T' -- edi work avtundhi kani... column names save avtledu..
quintin Posted September 4, 2014 Report Posted September 4, 2014 Save results as csv chesi try chesava or you can copy the results with headers and paste special as test ( if the size is less ) or csv lo chesi u Can insert row and add field names
Sambadu Posted September 4, 2014 Author Report Posted September 4, 2014 Save results as csv chesi try chesava or you can copy the results with headers and paste special as test ( if the size is less ) or csv lo chesi u Can insert row and add field names manual work undakudadu kada bro.. ela chesthe.. lead gadu .. oka look vesi potadu.. antha auto undali..apude..they lik it
Hyderabad_Nawab Posted September 4, 2014 Report Posted September 4, 2014 oka table output Excel lo save cheyali... but table columns name save avtledu.. yemina way undha.. ?? EXEC master..xp_cmdshell 'bcp "select * From master.dbo.final" queryout C:\TEST.xls -c -T' -- edi work avtundhi kani... column names save avtledu.. Nenaithe Direct ga Copy With Headers Chesi ..Excel lo Paste Chesi..Ctrl+A Type Chesta...:)
sunnygm Posted September 4, 2014 Report Posted September 4, 2014 Export cheyi from table to excel..you have option to give column names. This is faster and easy. #4H# #4H# #4H#
Suhaas Posted September 4, 2014 Report Posted September 4, 2014 column names union cheyyi query lo. Select 'Col1','Col2','Col3'... UNION Select * from Master.dbo.final
Recommended Posts