MIE Software Support Note
|
Subject: |
Troubleshooting - Importing demographics from a MS Excel spreadsheet |
| Applies To: | All products |
| Date: | 24 February 2003 |
Scenario
After importing names and addresses from an Excel spreadsheet, you notice
that only half of these names and addresses have been imported into your
Summit database.
Reason
Your Excel spreadsheet may contain zero length strings which can disrupt
the import process.
Solution
Complete the following steps:
- Open your Excel spreadsheet
- Select the entire contents
- From the Edit menu, select the Replace option
- The Find What field must be empty
- In the Replace With field, hit the space bar on your keyboard once
- Ensure that the Match Entire Cell Contents box is ticked
- Click Replace All
- Re-save the spreadsheet and try the import again
