Importing Large Amounts of Data

I pull in sales data sometimes and it's much larger than a standard Excel
work sheet of 65,536 lines. I'm using Excel 2003 and was wondering if I
could somehow import my data and when it gets to the end of a work sheet
that it would start importing into another work sheet. Is this possible?

Thanks....Mark

Here's what Dave Peterson suggested in response to a similar question:

http://groups.google.ca/groups?&thre...2AB3%40msn.com

'====================
I'd use my favorite text editor to split it up into many pieces (and
import each piece separately).

Or you could use a macro that imports each line:

http://support.microsoft.com/default...;EN-US;q120596
XL: Importing Text Files Larger Than 16384 Rows
(written for xl95, but has a note to change stuff for xl97+)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
'===============================

Mark McWilliams wrote:
> I pull in sales data sometimes and it's much larger than a standard Excel
> work sheet of 65,536 lines. I'm using Excel 2003 and was wondering if I
> could somehow import my data and when it gets to the end of a work sheet
> that it would start importing into another work sheet. Is this possible?
>
> Thanks....Mark
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html