Hi Paul, Appreciated your reply,
I have downloaded a cvs file (from an online tool in my office and also from MS Access) and I try to view in Excel. It saturates number of row.. On 4/24/09, Paul Schreiner <schreiner_p...@att.net> wrote: > 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
