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 ...

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." ...