Importing Data

[Guest]

When importing a large file into Excel that flows over the limit of one
worksheet, is there a way to have it automatically flow to the next sheet?

 

[PY & Associates]

We will need a macro to import line by line and keep counting. Once line
number exceeds a preset limit, switch to next sheet please.

Cheers

 

[Guest]

Can you point me in the direction of an example of such?

 

[PY & Associates]

This is one of THE most faq.
Google with key words "line input" will give you tons of it please.

 

[Dave Peterson]

Microsoft has a macro solution that may help:

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+)

I'd just use my favorite text editor and split the data into smaller pieces--and
then import each piece to a new worksheet.