ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to exclude data that has already been imported? (https://www.excelbanter.com/excel-worksheet-functions/80066-how-exclude-data-has-already-been-imported.html)

pjboys9699

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.

Pete_UK

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