in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » T-SQL » excel (RSS)

Browse by Tags

  • 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-us;281517
    Posted to Madhivanan (Weblog) by Madhivanan on Mon, Jun 22 2009
  • 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 proc_generate_excel_with_columns ( @db_name varchar...
    Posted to Madhivanan (Weblog) by Madhivanan on Fri, Oct 10 2008
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems