Get external data from Access in Office 365

[Bob L]

So I had Excel 2016 and to import data from Access, I would go to the Data tab, Get external data from Access, choose the database and the table and Excel would create a connection which I could customize with some SQL. I just switch to Office 365 and when I try to do the same, Excel creates a query with Power Query instead. What can I do so Excel creates a connection like in 2016?

Thanks.

 

[Bob L]

For those who wanted to know:

• Go to File > Options > Data
• Check the box From Access (Legacy) > OK
• Data > Get Data > Legacy Wizards > From Access (Legacy)