Sunday, May 26, 2024
HomeMicrosoft ExchangeError importing an Excel database into SQL Server

Error importing an Excel database into SQL Server


Error importing an Excel database into SQL Server: An exterior part threw an exception. (System information)

 

——————————

Program Location:

 

en System.Information.OleDb.DataSourceWrapper.InitializeAndCreateSession(OleDbConnectionString constr, SessionWrapper& sessionWrapper)

en System.Information.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)

en System.Information.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions choices, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

en System.Information.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions choices, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)

en System.Information.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)

en System.Information.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)

en System.Information.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

en System.Information.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

en System.Information.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

en System.Information.OleDb.OleDbConnection.Open()

en Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)

en Microsoft.SqlServer.Dts.DtsWizard.Step1.OnLeavePage(LeavePageEventArgs e)

 

How can I resolve that downside? I’ve put in the 32-bit and 64-bit model of Microsoft Entry Database Engine 2016 Redistributable and with neither of them it really works, it nonetheless provides me the identical error. I’ve 64-bit Workplace put in.



RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments