Browse by Tags

All Tags » Export to Excel » sql server (RSS)

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 would include column names in the file and file should exists already with headings This procedure would solve that problem create procedure...
Posted by Madhivanan | with no comments

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...