InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 22:14:43 GMT20http://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspx[quote][b]ravi@sql (1/10/2013)[/b][hr]No actually i exported 3 lakh records with around 150 columns dude , i splitted the records based on source using query . for that only it was taking around 1.5 hour to export.:crying:[/quote] it will/should as data transfer rate will be dependent on certain factor like cpu, memory and IO.Thu, 10 Jan 2013 23:29:59 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspxNo actually i exported 3 lakh records with around 150 columns dude , i splitted the records based on source using query . for that only it was taking around 1.5 hour to export.:crying:Thu, 10 Jan 2013 23:15:08 GMTravi@sqlhttp://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspx[quote][b]ravi@sql (1/10/2013)[/b][hr]Hi thank you all for the support. Finally i exported data using SSIS and it works fine .Regards,Ravindranath.s[/quote]can u please explain how ?because for excel 2007 ,row limit is 10,00,000 and you mentioned that there are 11,00,000 + records in table.Thu, 10 Jan 2013 23:08:18 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspxThat is good to hear.Thu, 10 Jan 2013 22:19:38 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspxHi thank you all for the support. Finally i exported data using SSIS and it works fine .Regards,Ravindranath.sThu, 10 Jan 2013 21:30:44 GMTravi@sqlhttp://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspx11 lakh is over the ~1 million limit of excel.Looks like you are out of luck.Thu, 10 Jan 2013 09:57:12 GMTarnipeturssonhttp://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspx[quote][b]ravi@sql (1/9/2013)[/b]I'll get sucess message but all data will not get copy to excel sheet .[/quote]Ravi, when you say "all data will not get copy", do you mean the rows that [i][b]do[/b][/i] get copied are *exactly* as they should be, but that some rows are missing? Or, are some of the rows that do get copied messed up? Did you, by any chance, import the data from some kind of text file? I had this issue one time when I imported some data from a text file as all varchar columns, which worked fine, but then I could not export it, keeping the columns as varchar. Then, I tried to re-import and convert to target datatype via the wizard. I found there were some non-printing characters in the data that I could not see. You could try (and it will be a pain), exporting the entire table to a text file, then re-importing with conversion. Set the wizard to fail on error, then look at the first record that causes a conversion failure. Maybe this is not an issue, but if you have any lf, cr, etc characters in your table, it could cause an issue.Thu, 10 Jan 2013 09:03:28 GMTGreg Snidowhttp://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspxwith no errors and not being in compat mode in excel - it sounds like you may have bad data that is getting discarded or you are exceeding the limits in excel 2007.Thu, 10 Jan 2013 08:40:28 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspxwhy so much of data on excel .it would be difficult to analyze it there (difficult to slice and dice) or even to scroll.from excel too , you can do this . see ther attachmentThu, 10 Jan 2013 01:19:16 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspxmore than 11 lakhWed, 09 Jan 2013 23:59:11 GMTravi@sqlhttp://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspxExact number of records?Is the spreadsheet in compatibility mode by chance?Wed, 09 Jan 2013 23:33:04 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspxsql server 2008 and .xlsx file...Wed, 09 Jan 2013 23:25:05 GMTravi@sqlhttp://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspxWhat version of SQL Server? What is the file extension of excel you are using (xls limits to ~65000 records where xlsx limits to ~1,000,000).If you have more than 1 million records, then the import to excel will not work properly.Wed, 09 Jan 2013 23:20:20 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1405185-391-1.aspxHi all, Am not able to export more than 10 lakh records to excel sheet(2007 xlsx). I'll get sucess message but all data will not get copy to excel sheet . I have tried through import wizard in sql server and also directly copy and paste to excel sheet.Apart from doing through ssis package i need help to perform this task.Regards,Ravi :)Wed, 09 Jan 2013 23:07:17 GMTravi@sql