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.
