Hi,

From checking previous instances of this error I have a few suggestions Sam:

Ensure no Excel processes are running by checking in Task Manager and try to import the file again
Transpose the information from your document into a new blank copy of the Import template which you can get online here:
desktophelp.sage.co.uk/.../ImportSupTrans.htm

Lastly, we have seen this error when there are formatting problems with the information. Examples of which are number 0's in columns where if no applicable information is needed then the column should be left blank. I would check against the Example file available from the previously linked help page to compare against your set of information.

Stu Mcalister

Hi Stu,

Thank you for the suggestions, but unfortunately they haven't solved the problem.


Sam

Hi Sam,

I'd recommend if you are a Sage 200 Standard or Sage 200 Education user to give us a call on 0845 111 5555 and we will assist. If you are a Sage 200 professional user then your Business partner can assist.

Stu Mcalister

Could be a couple of things, check the file extension is CSV - and that there's no hidden extension eg import.csv.txt or something like that. Try opening in Excel and save as ANanotherName.CSV and try that. If all else fails, get a copy of the standard Suppliertransaction.csv and copy the contents of the file (excluding the headers) into this and try again.

Or... one that just came to me - the file you are trying to open - ensure its not open in Excel or Notepad etc.