EXCEL tutorial 17: Importing data from an Access database with Power Query
🙏 For a donation → https://www.paypal.me/FrancescaMartorana
💻 For a #Microsoft365 subscription → https://amzn.to/3cLYiN4
📗 Request the #Excel workbook I created specifically for this course, using the contact form on my website → https://www.FantasticaMenteING.com 🌍
〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️
MICROSOFT EXCEL - Video course in Italian 📊 Tutorial 17: HOW TO CONNECT EXCEL TO A MICROSOFT ACCESS DATABASE VIA POWER QUERY
〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️〰️
In this tutorial, we'll see how to:
◾ Import data from external sources into Excel with Power Query
◾ Import data from an Access database
◾ Transform imported data using the #PowerQuery editor
📌 HOW TO CONNECT TO AN ACCESS DATABASE
Click the Data tab, then Get Data → From Database → From Microsoft Access Database.
In the Import Data dialog box, browse for the file you want to import.
Follow the steps in the Navigator dialog box to connect to the desired table or query.
Click Load or Edit.
📌 CONNECT TO AN ACCESS DATABASE
Click the Data tab, then Get Data → From Database → From Microsoft Access Database. If you don't see the Get Data button, click New Query → From Database → From Access.
In the Import Data dialog box, browse for or type a file URL to import, or link to a file.
Follow the steps in the Navigator dialog to connect to the table or query of your choice.
See you in the next lesson!
Francesca Martorana, Eng.
If you want to learn more about Excel, I recommend these books:
📗 Working with Microsoft Excel 2016. User's Guide: http://amzn.to/2DD1xZr
📙 Excel 2019 For Dummies: https://amzn.to/2Uq4Rv1