You're WAY to frugal with your info... "I have a data" ... What FORMAT is the data in? Where are you getting it from? "is more than the capacity of excel 2002". Is it because if there is too many rows? or too many columns?
I mean, the answer if your file is: a) a text file b) that is sent from someone else (you don't have control of the source) and c) it has a million lines that are broken into 1,000 columns is a COMPLETELY different answer than if the data is coming from MicroSoft Access and your QUERY is returning the same million rows. Paul ________________________________ From: raafi barey <raafiba...@gmail.com> To: excel-macros@googlegroups.com Sent: Friday, April 24, 2009 6:22:42 AM Subject: $$Excel-Macros$$ Excel-Help Hi, I have a data which is more than the capacity of excel 2002..how can i retrieve the complete data..ny possibilty of loading into seperate sheets.. Regards Raafi --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---