I am trying to import a text file into excel.

Right before the import takes place, I get a dialog box that states:

the text file contains more data than will fit on a single worksheet.

To continue and import as much of the data as will fit, click ok. You can then import the rest of the data by repeating the import operation on another worksheet and using the text import wizard to exclude data already imported.


Is there anyway to code this with doing this automatically into the next sheet? Or Any other way I'm using excel 2010.

Thanks,
E