Skip to main content

Error: 'ProcessImportFile Error: Incorrect syntax near 'XXX' when importing transactions

Updated over 3 months ago

This error occurs for two reasons:

  • The MIF isn't in the correct format. If this is the case, you may also receive errors on the Transaction Audit Report.

  • The MIF file includes special characters (e.g. apostrophe).

To resolve:

  1. Open the MIF file in Notepad and check that it is in the correct format.

  2. If the file is in the correct format. Search the file for the text mentioned in the error message. A special character has been included in one of the fields, e.g. Job Code. Update the file so there are no special characters.

Did this answer your question?