After you have exported your lists to your desktop (or other location) as IIF files, you need to open these files in Microsoft Excel. edit the files, and then save them again as IIF files.
- Open the IIF file you exported from your company file in Excel.
- Open Microsoft Excel.
- Choose File > Open (if using Excel 2007 choose the Office Button > Open>).
- Choose the location where you saved the .IIF file.
- Change the file type field in the bottom of the window to All Files.
- Choose your IIF file and then click Open.
- Click Next > Next > Finish in the Text Import Wizard, the IIF file is now opened in Excel.
- Make the necessary edits using Excel.
- Save the changes you made to the IIF.
- Choose File > Save (if using Excel 2007, choose the Office button > Save).
- Click Yes on the prompt that appears.
- Exit Excel.
- You will be prompted to save the IIF file again, click Don't Save.
- You are now ready to import the edited IIF to your company file.