Browse by Tags

All Tags » Export to Excel (RSS)
10 October 2008 15:55

Export to EXCEL with column names

In the post Import/Export to Excel , I showed how to export data to EXCEL The problem that most users find it is it wont include column names in the file and file should exists already with headings This procedure would solve that problem create procedure...
Posted by Madhivanan | 1 comment(s)
Filed under: , , ,
27 August 2007 16:23

Import/Export to Excel

Apart from using DTS and Import/Export wizard, we can also use this query to export data from SQL Server2000 to Excel and vice versa To export data from SQL Server table to Excel file, c reate an Excel file named testing having the headers same as that...
Posted by Madhivanan | 6 comment(s)
Filed under: , , , ,