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...
olafhelper
Bronze Contributor
I don't see any usefull information (in the error message). How do you try to import the Excel file; you haven't mentioned that?
Oscar9000
May 16, 2024Copper 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.
- SivertSolemMay 16, 2024Iron ContributorIt 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.