Reply To: CLM847 error message

#287404
sbrooksbank
Participant

Hi
We did have the same issue and also got referred to the developers. But in the meantime,the support desk advised to save the .csv file without opening it, then open Excel and use the ‘get data’ feature to pick the file up. They said it was in the SHBE guide as below.
5.3.4.1 Opening the CSV file
To help with formatting you will need to import the file into Excel rather than opening directly in Excel.
1. Open a new Excel book.
2. From the Data tab, select the From Text/CSV option.

Point 2 does not say Get Data which is a different drop down and then pick up from file.
The other instructions are the same. It worked for us and I hope it will work for you.