INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\temp_auto\dr_rep\Coimbatore_Daily_Report.xls;', 'select * FROM [Collection$]') select * from #temp2_Coimbatore_col
As i need, to display comma value of sql data values to excel and also display comment in excel format. How to write the sql query ?
Please any one help immediately solution for me..
I need immediately solution for this questions. Advance thanks for friends