To enable external data connection in Excel, you need to open the Options wizard and go to the Trust Center Settings. Then, head to the External Content tab and find the Security settings for Data ...

Excel displays a table with retrieved records that return as a result of the underlying SQL query of the data source by the Query Wizard. View the SQL query to see how the code retrieves data from ...

Click "OK" to return to the Data Connection Wizard, which now lists the database's tables. Click the table whose data you want to export to Excel. Click "Next." ...