![]() |
How to exclude data that has already been imported?
I have over 90,000 records in my text file and I would like to import the
records into Excel. I am only able to import the first 65,000+ records but receive a message that through the Text Import Wizard I should be able to exclude data already imported and import remaining data into another worksheet. |
How to exclude data that has already been imported?
If you start Excel then do File | Open and point to a .txt file, you
will be taken automatically into the Data Import Wizard - here you can specify the start row for the import (up to 32k). If you leave this blank then Excel will start on row 1 and will import up to 64k (65536 rows). If you import it again starting at 32k (32768) you will then be able to import from 32k to 96k into a different workbook. You can either delete the last 32k rows in the first workbook, or the first 32k rows in the second workbook, and then copy the second worksheet into the first workbook. If your text file is named .csv, you should rename it to .txt. Hope this helps. Pete |
All times are GMT +1. The time now is 05:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com