Epicor Service Connect using excel2xml.dll error - “Unexpected error from external database driver (1)."

Our company uses Service Connect to import Excel file into Epicor directly.

Last week, I have updated our server with the latest Microsoft patches. Suddenly, the Service Connect stopped working.

If you go to the document tracking in service connect, it doesn't give you information as it has failed very early.

If you go to the Events > All logs, then you will see the error "Unexpected error from external database driver (1)."

I did some google search and found out the two KB that caused the error. I am running Windows server 2008 R2. The two KB are KB4041681 and KB4041678.

Uninstall them and the excel2xml will start working again. 

Epicor E10 Administration Console 'MMC could not create the snap-in.' Error

I am sure someone else has the same problem. Our company is running Epicor E10.0.7.4 on Windows Server 2008. Everything installed fine, sometimes when you click on the icon for Epicor Administration Console it will come up with boxes saying "Unhandled Exception in Managed Code Snap-in".

At first, I thought there must be something wrong with the installation, I uninstalled and reinstalled the whole Epicor installation but still didn't fix the problem. One of the trick I tried that works for me is to SIMPLY run the console with "Run as administrator", or alternatively go to the properties of the short cut and enable "Run as Administator" in the Advanced button. I hope this can help someone.

Epicor E10 - How to use Excel data connection to connect to SQL Server

1. Open Excel and select Data Tab > From Other sources > From SQL Server

2. Enter the Server name and login details to the SQL server

3. Once connected, you can select the database and the particular table

4.Last step is to Save Data Connection File

5. Select the location where to put the data

6. The data come out is a table with the connection

7. If you create a Business Activity Query from Epicor E10, you can use it directly in Excel, simply right click onto the Table and Edit Query, then paste the BAQ.