large (.TSV) file import

Trying to import a .tsv file with 2.5 million lines of data. When importing, the file fills the first sheet to 1,048,576 lines and then displays the message "the input is incomplete". Question is, how can we get the data to continue onto other sheets in the workbook?

Thanks for any suggestions.

Maybe try to import it to Access not Excel?

Thanks for the suggestion, but unfortunately it doesn't recognise the file type.