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.