I have a text file which has data(sample data below), i
need to import data directly into the excel sheet

I need to import from the text file phase by phase,i.e if the (text
file) data exceeds 65536 rows then it has to put it in next sheet.

the data is in this format wherin comma is a delimiter

7,.,20,de05c,,,52,1.2,52
7,.,21,de05c,,,2,1,2