Excel as a front end to sql, data integrity
how do I put a value in a sql field that will not be counted in a excel pivot table? I am using excel as a front-end to sql. In particular, I am using pivot tables to slice and dice sql tables. The field I am interested in has either a text value or a [...]

Answer Question   |  July 27, 2010  6:00 PM
Excel Database, SQL 2005, SQL Export to Excel, SQL Server, SQL to Excel Database Conversion

SQL To Excel Data Dumping with the help of SSIS flow task.
I am trying to do a Sql To Excel Data Dumping with the help of ssis flow task.I create a sql connection and give the query in the sql source.I aslo have a excel template to map in excel destination ready which has around 400 columns/fields.In bettween i use a dataconvrsion for unicode/non unicode issue.Now [...]

Answer Question   |  July 19, 2010  3:37 PM
Excel 2003, Excel Metadata, SQL Server database, SQL to Excel Database Conversion, SSIS Package

Converting SQL 7 Database to Excel
Hi, I would like to know any possible way of converting my Sql 7 Database to Excel formats. Any ideas anyone. Thanks

Answer Question   |  November 4, 2009  7:37 AM
Microsoft Excel, SQL, SQL 7, SQL to Excel Database Conversion