When trying to import a file which should create a gift batch I am receiving the following error, I cannot find what column this is referring to. Can anyone help, this is quite urgent.
Line 1: Error saving batch on data row # 1. Error = 'General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of the varchar value '-2147219858' overflowed an INT2 column. Use a larger integer column.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
Thank you for sending in your files to Support.
The error you were seeing, "ERROR  [Microsoft][ODBC Excel Driver] Syntax error in FROM clause" was due to the MasterIDs file.
The file needed to be renamed to MasterIDs.xls and the space in the column header for MasterID needed to be removed: