Importing Data from Excel to Microsoft Access
ฝัง
- เผยแพร่เมื่อ 5 ก.ย. 2024
- In this Microsoft Access 2021 training course, we will take a guided tour and walkthrough, looking at importing data from an Excel spreadsheet into an Access database.
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ www.simonsezit...
🚀 Level up your skills with a free 30-day trial to our complete training library of 10,000+ videos ⏩ www.simonsezit...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Data Analysis using Microsoft Tools 👉 • Data Analysis using Mi...
✅Microsoft Access Training video playlist 👉 • How to Use Microsoft A...
✅ Microsoft Excel Beginner's Training here 👉 • Microsoft Excel Beginn...
✅ Introduction to Databases Training here 👉 • Introduction to Databa...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT...
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
www.youtube.co...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
1.-If i have 30 excel sheets, it a lot a work to pass them into access ?
2.-It is a lot easer to do it in power query, then attached it to access , to link them to diferents tables
This video would have been much more valuable had you given some of the most common errors users would get when their excel file is not formatted or saved properly for Access to import records! A common error most users will receive is “Subscript out of range”
Thank you, this was exactly what I needed.
You are very welcome! Thanks for watching 😃
Hi, is it possible to get data from an excel file attachment in an email to MS Access?
Nice
Did i seriously just watch a video to import Excel data, only to get to the end and be told we are not going to import data from excel....? Seriously?
👌👌👌
6/10 edge need better content