This is usually a sign that your Excel spreadsheet has some funny hidden characters or programming in it. Just copy all the lines you wish to export into Notepad (or Textedit on your MACs) first, then copy from Notepad before importing into mydaEs. Notepad will strip out any illegal characters so that your imports will work correctly.
- Copy the data from Excel (from ‘Acct No’ to ‘Gross’)
- Open ‘Notepad’ (Windows) or ‘Textedit’ (Mac)
- Paste the contents.
- Select all, then copy the text.
- Import as usual