I've got a text file that I am attempting to import (over 65500 lines) and of
course I'm getting the alert for the size limit for one worksheet. However,
Excel does prompt me with the following message. Can someone give me a quick
description of how to rerun the import on another tab and EXCLUDE the
previous data? I've attempted this but it seems to just import the same
data. I've looked in the options for some sort of setting, but have not
found anything useful.
Thanks in advance...
"The text file contains more data than will fit on a single worksheet.
To continue and import as much of the dta 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."