Forum Discussion
Oscar9000
May 14, 2024Copper Contributor
Error importing an Excel database into SQL Server
Error importing an Excel database into SQL Server: An external component threw an exception. (System data) ------------------------------ Program Location: en System.Data.OleDb.DataSourceWra...
Oscar9000
Copper Contributor
olafhelperFirst from a database already created, I right click and then in tasks, then in import data, I choose that the source will be excel, then I select the excel file that contains the tables but when I give next I get the error of An external component produced an exception. (System. Data), previously I did it this way, it let me load the data without problem, but now I get the error, I have installed the Microsoft Access Database Engine 2016 Redistributable 64-bit and 32-bit, with both it worked before, now it does not work with either, I use Office 2019 and I have Windows 10 Pro, what can I do to fix the error?
I attach screenshots of the error.
SivertSolem
May 16, 2024Iron Contributor
It could be worth attempting to start "SQL Server xxx Import and Export Data" from your start menu.
It's in the "Microsoft SQL Server xxxx" folder.
It's in the "Microsoft SQL Server xxxx" folder.