in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » SQL Server » 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

  • Pivot table connectivity to SQL Server Analysis Services - security gotchas

    Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database to fetch the data. As per the configuration when...
    Posted to SQL Server Knowledge Sharing Network (Weblog) by ssqa.net on Fri, Mar 14 2008

  • 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 of table columns and use this query insert into...
    Posted to Madhivanan (Weblog) by Madhivanan on Mon, Aug 27 2007
Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems