How to exclude data from a text file which is already imported

[Bhanu Prakash]

Hi, I am trying to import a text file, basically its a XYZ file, having rows of 9403352. When I import data in a worksheet, it imports the data till 1048576 rows. A warning message also comes that "....You can import the rest of data by repeating the import operation on another worksheet and using the Text Import Wizard to exclude data already imported". 

But I am unable to find a option to exclude the data already imported. 

Anyone please help.

[#2]

Hi Bhanu,

If you use legacy Text Import Wizard on the first step you see an option from which row to start the import - put here one next to already imported.

Other words, if you import into one worksheet 1,048,576 rows (which is the size limit, see https://support.office.com/en-us/article/Power-Query-specifications-and-limits-5fb2807c-1b16-4257-aa...), on next import start from 1,048,577

Alternatively you may load entire file to data model using PowerPivot/PowerQuery connectors (not into the sheet, into the data model). They also have some formal limits, but actually that's limited only by your PC memory size.

[#3]

Dear Sergei,

Thanks for your valuable reply. I had tried the same. However I again tried but I am not getting the data imported into my excel worksheet.

While running text wizard, if I put the value as 1048577, data is not shown in the preview window and on completion of the wizard, only the column 1 value of 1048577 row is getting imported.

Thanks,

Bhanu

[#4]

Did you import into the new clean workbook?

[#5]

Hi,

Earlier I was trying to import into new worksheet but today i tried the same into the new clean workbook. The result is same as earlier.

Thanks.

[#6]

did you figure it out ? I'm also trying to do the same ?