Browse by Tags

All Tags » excel (RSS)

Export to Excel - data length exceeds 255 characters

If you use Data Transaformation Services to send data to EXCEL, you may get error about the size of the cell if length of data exceeds 255 characters. This KB from microsoft explains how to solve it http://support.microsoft.com/default.aspx?scid=kb;en...
Posted by Madhivanan | with no comments
Filed under: , ,

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

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