importing records from excel - having trouble
I am trying to import records from an excel document. I just completed these process for two records, and now I want to update another 18 records. I go to import records, and select the file. All the information that I want shows up correctly, i choose update matching records, i do the equal sign to match the records, and the --> sign for the information that i want to update. I click import and the summary comes up with 0 records changed. I don't know what I am doing wrong.
You'll need to examine your match field's contents and compare to the specified column in your spread sheet. Apparently the values look like they match but don't actually match. One possibility is that you have an invisible character, such as a space in your match field or the spreadsheet column (if the data is text).