Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SSIS and Import/Export (2008)  Top 50 Rows extract to excel from database

Author  Topic  kumarsk9 Starting Member 1 Post Posted - 2011-08-08 : 11:43:40 I am trying to import data from database into excel .Following is criteria • Need to make connection between database and excel > done • In excel cells if we enter name of database and server name then there should be button as refresh then it takes value from cell and extract records • Most important it should extract all tables and distribute it in excel sheet as table_1 to sheet1 and table 2 to sheet 2 of excel book • Total records that need to be extract is top 50 rows Let me know if you have came across that requirement To me it looks like it can be done by defining some macros and vb script or stored procedure . Data base is : SQL SERVER 2008 Eccell : 2007 If some one can guild my steups i would reall appreciate that and thank you for your help Server Name DB server Database Name Adventure works Refresh [/u]