Spliting the file should update only the rows included in the file.
When using the re-import feature CRM will add some additional column to the export file. These columns contain the guid of the record and some additional information, by default these columns are hidden. When deleting rows be sure to delete
the entire row not just the values.
To view these columns select the entire sheet (click on the box in the left top corner of the cells), right click on the first column (D) and choose unhide. Ensure that when you delete a row you also include the first columns.
An alternate way of spliting the file is:
- Open the file
- Create a new (empty) excel file
- From the source file Select the entire first row (click on the '1')
- Copy past this row to the empty file
- From the source file select a set of rows to import (e.g. start with 2-5000)
- Copy and past these rows to the new file
- Save the file as "XML Spreadsheet 2003 (*.xml)"
If the file is less than 8Mb you can copy additional rows.
When copying the rows the first column will contain a guid, the second a 'random' set of characters and the third a date followed by your data. Ensure that the first three columns are copied and not modified (this is the reason why they are hidden).
Patrick Verbeeten
www.patrickverbeeten.com
www.wavextend.com
