Start a new topic

Batch Import Exceptions

When trying to run an import of a CSV - receiving exceptions.  This happens regardless of the file we try to use.  See below for output:



IOM Version: 3.4.1.0 RE Version: 796.6402.14

Profile: AC - Lockbox Import

REImport Error File

Import Source: S:\Development\Applications\US Bank Lockbox\Downloads\US Bank Data Files\l300.l30dpofe.xf00.20191216.085133-12.16 IMPORT.CSV

Master ID File: S:\Development\Applications\US Bank Lockbox\Downloads\US Bank Data Files\Support Files\MasterIDs.xls

 

Source row 1 produced Excel error row 2: ERROR [42000] [Microsoft][ODBC Excel Driver] Syntax error in FROM clause. -->System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)-->System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)-->System.Data.Odbc.Od

 

Source row 2 produced Excel error row 3: ERROR [42000] [Microsoft][ODBC Excel Driver] Syntax error in FROM clause. -->System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)-->System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)-->System.Data.Odbc.Od

 

Source row 3 produced Excel error row 4: ERROR [42000] [Microsoft][ODBC Excel Driver] Syntax error in FROM clause. -->System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)-->System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)-->System.Data.Odbc.Od

 

Source row 4 produced Excel error row 5: This record was skipped by the user.

 

Source row 5 produced Excel error row 6: This record was skipped by the user.

 

Source row 6 produced Excel error row 7: ERROR [42000] [Microsoft][ODBC Excel Driver] Syntax error in FROM clause. -->System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)-->System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)-->System.Data.Odbc.Od

 

Source row 7 produced Excel error row 8: ERROR [42000] [Microsoft][ODBC Excel Driver] Syntax error in FROM clause. -->System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)-->System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)-->System.Data.Odbc.Od

 

Source row 8 produced Excel error row 9: ERROR [42000] [Microsoft][ODBC Excel Driver] Syntax error in FROM clause. -->System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)-->System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)-->System.Data.Odbc.Od

 

Source row 8 produced Excel error row 10: Import canceled by user

 



looks like there could be an issue with either your import file and/or profile - can you share the import profile and sample data for review.  Thanks, Dennis dennis@ladnierfamily.com

Hey Dennis! Thank you for your response.  I meant to post in here that we actually figured it out.  One of our users inadverdantly saved the MasterID file as .xlsx 


After changing it back to .xls, we're good to go

Laura, that's great news - glad you figured it out and it was nothing major.


Thanks, Dennis dennis@ladnierfamily.com

Login or Signup to post a comment