1. In Excel, open the file and save it as a .csv file.
2. Open the .csv file in Notepad.
3. Scroll to the bottom of the file and delete any empty rows at the end.
4. Save and close the file.
5. Verify the settings in Connect are set to comma delimited.
6. Process all importing steps again in Connect.