Error During Import From Microsoft Excel / Print Labels and Envelopes

Description

The client log contains this error:

--- HASH: 1547F8EAA72185127F7212C56ACD1CB7 ---
Unable to read data from Excel
System.Data.OleDb.OleDbException (0x80004005): Unspecified error
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at eWay.Core.DataImporter.ExcelDataReader.ReadData(String connectionString)
at eWay.Core.DataImporter.ExcelDataReader.ReadDataFromFile(String filePath)
--- END TRACE ---

Versions

All versions of eWay-CRM

Difficulty

Medium

Resolution

You need to install or reinstall Microsoft Access Database Engine 2010: https://www.microsoft.com/en-us/download/details.aspx?id=13255

  • You have 64-bit Microsoft Office: You need to install 64-bit Microsoft Access Database Engine 2010.
  • You have 32-bit Microsoft Office: You need to install 32-bit Microsoft Access Database Engine 2010.