Created Sage TRANS.CSV file will not import into Sage

[norman]

You get the message - "Unable to read any fields from the data you're trying to import"

This message appears if the file extension is in upper case, for example TEST.CSV or test.CSV. It needs to be TEST.csv or test.csv. It may also appear if there is a symbol in the folder name where the file is stored.

Solution

Rename the file to change the file extension to lower case. If the issue still occurs, check the folder name does not contain any symbols when you browse to the file in the Data Import wizard. If the folder does contain symbols, rename the required folder and import the file again.

Previously the case of the extension did not matter.

Norman