Importing Large Amounts of Data

[Mark McWilliams]

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]

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

http://groups.google.ca/groups?&[email protected]

'====================
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.aspx?scid=kb;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
'===============================